Home : Products : Hach WIMS : Hach WIMS Client : Documentation : Function Reference : Spread Functions : Date Functions : DATE
Q10673 - INFO: DATE

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, DSORTWDATE, 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)

 

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 1/27/2008 11:16 AM.
Last Modified on 2/4/2016 4:13 PM.
Last Modified by Scott Dorner.
Article has been viewed 3337 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article