The following functions operate on fields with standard date formats:

• DATEADD: Adding or Subtracting a Date Unit to or From a Date
• DATECVT: Converting the Format of a Date
• DATEDIF: Finding the Difference Between Two Dates
• DATEMOV: Moving a Date to a Significant Point
• FIYR: Obtaining the Financial Year
• FIQTR: Obtaining the Financial Quarter
• FIYYQ: Obtaining the Financial Year and Quarter

The other way to supply a date to a standard date function is to use a natural date in a character string, enclosed in single quotation marks. For example, '20040311' is the natural date that corresponds to '2004 March 11'. In another natural date example, you can assign the field CURDATE to the value of the current date using the system variable &YYMD in natural date representation, as follows:

CURDATE/YYMD = '&YYMD'