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?
Page 1 / 1
Hi 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 ) ))
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.