Calculate the date range exclude weekend

0
Have any idea for calculate the date range exclude weekend?
asked
1 answers
0

Hi Wei Jie Sow,

 

1. Create a variable of type date with initial value as start date and create a count variable.

2. Check if the trimtoday($variable) = 1 or 7.

3. If true continue the loop by using change variable by add date 1.

4. Else increment the count.

5. This loop will execute until variable < end date.

6. The count variable will be the days between start and end.

Hope my answer helps

 

OR

 

Can you try this module!

Date Time Utilities

 

OR

 

Try this ! Working Days

answered