WDATE returns the end date of a week.

SYNTAX:

WDATE(Offset,Format,Not Used, WeekDef)

Offset:  Sets the number of week groups from the start date of the report.

Format:  The format that the date will be printed in. See here for format explanation.

Not Used: Set to 1 for function to work.

WeekDef: Defines the week.  IE 7 is  Sunday thru Saturday.   Click here for a table defining weeks and the corresponding values for n.  Returns results for any week regardless of the report dates.  IE  7 with an offset of 53 would return Sunday thru Saturday for one year from the start date of the report even if the report date range is one month. 

NOTES:

Function WDATE has been replaced by the GDATE function.  It is documented here only for older reports that still use the WDATE function.

EXAMPLES:

WDATE(2,"mm/dd/yy ddd",1,7)  Shows the end date for the 2nd (Offset 2) Sunday to Saturday (Weekdef of 7) week. 

 

Download Example Template: Help_WDATE.ss3 (Click here for download instructions)