I use the work_time_calendar_api.get_work_days_between() function in several of my SQL scripts, and it works great. Is there a way, using the work time calendar, to calculate a date from a given date with a delta?
For instance (pseudocode): get_work_days_between(calendar,‘2024-09-03’,’2024-09-05’) will return 2 in my environment.
Is there a function that exists that will allow a date argument ‘2024-09-03’ and a variable argument of ‘2’ and return the value of ‘2024-09-05’?
thanks!
Eric