I want to calculate cycle time -difference between received date and closed date in days which includes only business days
Exclude weekends and public holidays
Using recordtype-new custom record field I wanna to achieve as I need to use in process hq reports
Thanks,
Priyadharshini. S
Discussion posts and replies are publicly visible
CREATE TABLE PUBLIC_HOLIDAYS ( holiday_date DATE, holiday_name VARCHAR2(100) );
Build rule!CALC_BusinessDays(startDate, endDate)
rule!CALC_BusinessDays(startDate, endDate)
rule!CALC_BusinessDays( startDate: recordType!YourRecord.fields.receivedDate, endDate: recordType!YourRecord.fields.closedDate )
Use networkdays(receivedDate, closedDate, cons!PUBLIC_HOLIDAYS) in a sync-time custom record field - this works cleanly in Process HQ reports. For dynamic holidays, maintain the constant by periodically syncing it from your holiday table via a scheduled process.