[AccessD] Parse Year

Hollis, Virginia hollisvj at pgdp.usec.com
Wed May 23 08:12:54 CDT 2007


How do I parse out the year in a query for dates in this format?

 

5/2/2005 10:23:44 AM

 

I need to create a query from Access data for a graph in Excel. The
graph needs to show the total number of projects completed each year.
The dates are formatted as shown above so I need to get the year to
group them by the year.

 

Virginia




More information about the AccessD mailing list