i want to add 1 business day to the calendar excluding sat and sunday so it should not count sat and sunday
Can you explain this?
Hi @T_Y_Raju
Try this:
Assign nextBusinessDay = If(currentDate.DayOfWeek = DayOfWeek.Friday, currentDate.AddDays(3), currentDate.AddDays(1))
please give your input in currentDate and DataType is System.DateTime.
If currentDate is of DataType System.String. then, please use the below syntax:
Assign nextBusinessDay = If(CDate(currentDate).DayOfWeek = DayOfWeek.Friday, CDate(currentDate).AddDays(3), CDate(currentDate).AddDays(1))
Hope it helps!!