10 tips for working with dates in Microsoft Access

Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. Database expert Susan Harkins offers some tips and examples to help you avoid problems and work more efficiently with dates. For example, she explains when to use Now() versus Date() or Time(); how to add an edit date to track who's making changes; how to use Format() to display dates; and how to sort by date components.

This download is also available as an article. Join the discussion and share your experiences and opinions.