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. 

Syntax:  

lastworkdate(start_date, no_of_workdays {, holiday})

Return data type: dual

Arguments:  

Examples and results:  

These examples use the date format DD/MM/YYYY. The date format is specified in the SET DateFormat statement at the top of your load script. Change the format in the examples to suit your requirements.

Example 1:  

lastworkdate ('19/12/2014', 9)

Returns '31/12/2014'  

Example 2:  

lastworkdate ('19/12/2014', 9, '2014-12-25', '2014-12-26')

Returns '02/01/2015 as a holiday period of two days is taken into account.

Example 3:  

Add the example script to your document and run it. Then add, at least, the fields listed in the results column to a sheet in your document to see the result.

ProjectTable:

LOAD *, recno() as InvID INLINE [

StartDate

28/03/2014

10/12/2014

5/2/2015

31/3/2015

19/5/2015

15/9/2015

] ;

NrDays:

Load *,

LastWorkDate(StartDate,120) As EndDate

Resident ProjectTable;

Drop table ProjectTable;

 

The resulting table shows the returned values of LastWorkDate for each of the records in the table.