MS Access: Date/Time

Tables

• Define a custom format for a Date/Time field in a table in Access 2007 | Access 2003/XP/2000/97

Queries

• Query to retrieve max date in Access 2007 | Access 2003/XP/2000/97

Forms/Subforms

• Popup calendar in a form/subform in Access 2007 | Access 2003/XP/2000/97
• Define a custom format for a Date/Time field on a form in Access 2007 | Access 2003/XP/2000/97
• Set up a text box to display a date value when another field has a value in Access 2007 | Access 2003/XP/2000/97

Reports

• Using WeekdayName function in a report in Access 2003/XP/2000/97

Formatting

• Set up a text box to flash red/black when a date is past due in Access 2007 | Access 2003/XP/2000/97

Miscellaneous

• Calculate and format an elapsed time value in Access 2003/XP/2000/97
• Convert a date to a numeric value in Access 2003/XP/2000/97
• Calculate the number of workdays between two dates in Access 2003/XP/2000/97
• Set up a text box to display the difference between two dates in Access 2007 | Access 2003/XP/2000/97