DATE returns a date.

SYNTAX:

DATE(Offset, Format, Interval)

Offset: Sets the number of ‘intervals' from the start date of the report

Format:  Date Format to display.  Common formats:

"mm/dd/yy" 01/01/96
"mmm" Jan
"mmm yyyy" Jan 1996

Interval:  The interval of time used with the Offset to calculate the date to print.  Values are:

1    Days
-1  Print the end date of the report
-2  Place the one day beyond the end date
3   Months 
4   Current Date

NOTES:

The easy way to place this function is to use Locate, Date.

SEE ALSO: GDATE, DFILTER, DSORT, WDATE, DWO, DATEADD

EXAMPLES:

The start date of the report is 1/1/2004 the end date is 1/31/2004.

Date(1,"mm/dd/yy",1)   Returns date as: 01/01/04

Date(2,"m/d/yyyy,1)  Returns date as: 1/2/2004

Date(-1,"m/d/yyyy,-1)  Returns the end date as: 1/31/2004

Date(-1,"m/d/yyyy,-2)  Returns one day after the end date as: 2/1/2004

Date(2,"mmm yy",3)  Returns date as: Feb 04

Date(1,"m/d/yy",-1)  Returns date as: 2/20/04 (current date is 2/20/04)