Question
Is there any function in PQL which calculate days such as networkdays (used in excel and it will ignore timestamps, exclude weekends ,conside start and end date )does?
+4Is there any function in PQL which calculate days such as networkdays (used in excel and it will ignore timestamps, exclude weekends ,conside start and end date )does?
+11Hi Sejal,
The below PQL compares the days between two date fields, specifies only the weekdays, and allows you to specify business hours as well
AVG(WORKDAYS_BETWEEN ( <%= date1 %>, <%= date2 %> ,
WEEKDAY_CALENDAR (
MONDAY 09:00 - 17:00
TUESDAY 09:00 - 17:00
WEDNESDAY 09:00 - 17:00
THURSDAY 09:00 - 17:00
FRIDAY 09:00 - 17:00 ) ))
Login to the community
No account yet? Create an account
Login with SSO
Celonaut Login Celonis ID LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.