QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

lastworkdate - script and chart function

The lastworkdate function returns the earliest ending date to achieve no_of_workdays (Monday-Friday) if starting at start_date taking into account any optionally listed holiday. start_date and holiday should be valid dates or timestamps. 


lastworkdate(start_date, no_of_workdays {, holiday})

Return data type: dual


Argument Description
start_date The start date to evaluate.
no_of_workdays The number of working days to achieve.

Holiday periods to exclude from working days. A holiday period is stated as a start date and an end date, separated by commas.

Example: '25/12/2013', '26/12/2013'

You can specify more than one holiday period, separated by commas.

Example: '25/12/2013', '26/12/2013', '31/12/2013', '01/01/2014'

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?