Date: Identify Next working day

[manojkulkarni]

HI Team,

I have requirement in which we need to exclude weekends & holidays while deriving the new transaction date.

eg; I have data received today but due to cutoff time we need to push it for next day. While calculating new date weekends & holidays needs to be ignored.

Request members to provide suggestions to implement. If anybody has already done similar then please share the code.

Thanks in Advance

[enozagar]

lastworkdate(start_date, no_of_workdays {, holiday})

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc...