Access Date Data Type Tutorial

By Adrian Pask on March 31, 2012 in Access Tutorial - Tables, Basic Access Class

Access Database Date Data Type

In Microsoft Access databases and spreadsheets dates are stored as a number value. The integer portion of a date variable is the day and the fractional portion of the date variable is the time of the day.

In Access, the date data-type is stored behind the scenes in exactly the same way as in Excel and VBA. The formatting options for dates in Access are exactly the same as in Excel or VBA, so if you are are familiar with Excel date formats you will be familiar with the Access date formatting options.

Dates are actually a very broad topic – in my other SuperStar courses I spend about an hour discussing the date data type and how it relates to text data types and numerical data types.