Home : WDATE
Q10818 - INFO: WDATE

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)

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/29/2008 12:00 PM.
Last Modified on 8/14/2008 3:33 PM.
Last Modified by Jan Bob.
Article has been viewed 3756 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article