Question

2
Replies
729
Views
Anil Kumar Borra Member since 2018 1 post
Infosys
Posted: 1 year ago
Last activity: 1 year 6 months ago
Closed

How to calculate business days based on specific calendar time zones.

As per our current requirement, If user select Install Quarter Date, Installation Date will be calculating based on last day of calendar date minus 10 business days.

Install Quarter Dates:
Q1- 31Mar
Q2- 30Jun
Q3- 30Sep
Q4- 31Dec
Installation Date = @addBusinessDaysToDate(Install Quarter Date, -10, 0, 0, 0, true, CalendarName)

Eg: @addBusinessDaysToDate( 20190930T000000.000 GMT, -10, 0, 0, 0, true, Cal_CA_2019 ) It returns

20190916T080000.000 GMT

- Observe that Installation Date is displaying as 16-Sep-2019 which is 11th business day.

We have multiple regions and Time zones will be changed based country.

Low-Code App Development Low-Code App Development Dev/Designer Studio Reporting
Moderation Team has archived post
Share this page LinkedIn