You don't need a complex set of expressions or even VBA to sort Access date values by specific components, such as month or year. Use DatePart() and sort on its results.

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. These tips will help ...

Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Ctrl+F3, Shift+A5…I ...

In this article, we are going to see an easy way to convert a string representation of a date to a date value.