Determine business day in the past

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi,

Requirement as below:

Determine 1 business day in the past (Business day = calendar day Monday-Friday). In this example 1 business day in the past would = 01/11/2024. If the listed create date is anything older than 1 business day (excluding Saturday and Sunday or today’s date), add a count of 1 to counter variable.

Regards
Sonali

[Anil_G (Anil Gorthi)]

@sonaliaggarwal47

Explained here..please check..xaml not sure if it is still working as it is old..but the logic is also written

Can anyone create a business working days workflow

@katta_nikhil Create a xaml with two arguments in_numberofdays of integer type, in_strtdate of datetime type and out_requiredate as datetime type and create a variable int_days Int he xaml one while loop condition as Not in_Numberofdays.Equals(int_days) Inside the loop use assign with out_requireddate = in_startdate.adddays(1) Now use if condition with out_requireddate.Dayofweek.ToString.Equals("Sunday") Orelse out_requireddate.Dayofweek.ToString.Equals("Saturday") On then side leave empty …

How to get the date of the previous business day?

@Betul_Dundar Please try this varDate = DateTime.ParseExact("20.12.2022 15:04:25", "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).AddMonths(1) If(varDate.DayOfWeek = DayOfWeek.Monday, varDate.AddDays(-3), If(varDate.DayOfWeek = DayOfWeek.Sunday, varDate.AddDays(-2), varDate.AddDays(-1))) [image] Hope this helps cheers

Cheers

[sonaliaggarwal47 (Sonali Aggarwal)]

Thank you It worked.