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?

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 ) ))