Some sample date expressions.
You can work with dates in calculations, such as subtracting one date from another or retrieving all dates that are earlier than today.
In Access, dates and times are stored as decimal numbers so that you can use them in mathematical equations. But for simple date calculations, you won't need to worry about what's happening behind the scenes because Access takes care of the math for you.
With Access, you can do more than just add and subtract dates. By using DatePart, you can display part of a date, such as the year someone was hired.
You can see some date expressions in the table to the left and in the Quick Reference Card at the end of this course.