Page 1 of 1

15 working days

Posted: Tue Nov 16, 2004 8:54 pm
by Mary_S_(Guest)
I would like to create a calculation that will yield a date that is 15 working days from today^s date - wizDate. Any ideas on how to do that?__Thanks for help.

=> RE: 15 working days

Posted: Tue Nov 16, 2004 10:45 pm
by kfleming
You would need to create a calculation that uses the DOW() function to decide how many days to add.__So if the system date is a Monday DOW(date())=2 to get 15 working dates you would need to add 19 days to accomodate the two weekends. __The calc would then have and IIF() test so that each DOW() would add the appropriate number of calendar days.__And if there were any holidays you would need to specifically factor them in as well.____Sorry that it is just the concept and not the actual calculation.____Kathleen__R&R Support

==> RE: 15 working days

Posted: Wed Nov 17, 2004 3:40 pm
by Mary_S_(Guest)
Worked like a charm - I used AddDays() and did an iif calculated field for each DOW and stacked them.__Thanks a lot