contents.gifindex.gifprev1.gifnext1.gif

Date

Purpose

Return the current system date.

Arguments

Date[$][( )]

Notes

The parentheses are optional only when you use Date[$] in Access Basic.

Date returns a variant (VarType 7) containing a date stored internally as a Double. Date$ returns a 10-character string of the form mm-dd-yyyy, where mm is the month (01-12), dd is the day (01-31), and yyyy is the year (1980-2099). Date$ returns a 10-character string of the form mm-dd-yyyy

The output of the Date$ function is equivalent to:

Format$( Now, "mm-dd-yyyy" )

To set the system date, use the Date[$] statement.