any function used in pql to calculate days between the two date column such as in excel networkdays does (consider start date and end date , exclude weekends, ignore timestamps)
Page 1 / 1
Try Remap_TIMSTAMPS, datediff, days_between
The WORKDAYS_BETWEEN function determines the amount of workdays between two given dates. It should work similar to the networkdays function in excel.
syntax - WORKDAYS_BETWEEN ( start_date, end_date, calendar_specification , calendar_id_column])
The WORKDAYS_BETWEEN function retrieves its information regarding valid workdays from the passed Calendar configuration. For more information on this, see the following link
https://docs.celonis.com/en/workday_calendar.html
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.