Hi, We have a requirement to return the previous working days, just like how ca

arjunv over 9 years ago

Hi, We have a requirement to return the previous working days, just like how caladddays() returns a date time based on given number of net work days after the start date time. Is there a way to achieve this?

Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 monikar over 9 years ago

workday function can be used to get the previous working day before certain number of days. This will exclude the weekends by default along with the holidays provided.

Ex: workday(starting_date: today(), days: -7, holidays: null)

The same function can also be used get the future working day when the days parameter is given as positive integer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 monikar over 9 years ago

workday function can be used to get the previous working day before certain number of days. This will exclude the weekends by default along with the holidays provided.

Ex: workday(starting_date: today(), days: -7, holidays: null)

The same function can also be used get the future working day when the days parameter is given as positive integer.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data