The Date data type stores a calendar date. A Date literal must be enclosed with number signs (#) and in the format YYYY-MM-DD. The supported range of this data type goes from 1900-01-01 to 3000-12-31.

Default value

#1901-01-01#

Example

#1998-08-08#

See Also

Built-in Date & Time Functions | About Null Values | Available Data Types