Syntax

Figure 1 shows the syntax for the DATE keyword.

Figure 1. DATE Keyword Syntax

[DATE (fromdate[,todate])]

fromdate: Specifies the start date for the records to include in your analysis.
todate: Specifies the end date for the records to include in your analysis.

If you specify only the fromdate, GFTAVMA selects only the records created on that date.

You can use any of the following formats for fromdate and todate:

mm/dd/yy: The month/day/year specified with 2 digit fields, for example: 03/15/04 or 3/15/04
mm/dd/yyyy: The month/day/year where the month and day are 2 digit fields and the year is a 4 digit field, for example: 03/15/2004
yyyyddd: The year and Julian date using 4 digits for the year, for example: 2005074
yyddd: The year and Julian date using 2 digits for the year, for example: 05074