Can anybody tell me how toadjust a extracted with x working day?
2 posters
Date functions
Jacob Bruun- Posts : 6
Points : 1843
Join date : 2019-11-11
Age : 64
- Post n°3
Re: Date functions
Yes, but I want to go one day back to the nearest bankday, so the date must not be a day in a weekend or a Holiday.
KenZink- Posts : 8
Points : 2570
Join date : 2017-11-15
- Post n°4
Re: Date functions
You could build some logic to determine what day the current day is using the expression editor to determine the day example weekday(date()) is going to give you Wednesday and then evaluate that looking for a Saturday or Sunday and then have it deduct the date value in the convert variable to reflect the previous friday date.
Jacob Bruun- Posts : 6
Points : 1843
Join date : 2019-11-11
Age : 64
- Post n°5
Re: Date functions
Thanks, that Works