Gustav Brock
Gustav at cactus.dk
Wed May 23 08:18:59 CDT 2007
Hi Virginia
Like this:
intYear = Year(DateValue("5/2/2005 10:23:44 AM"))
/gustav
>>> hollisvj at pgdp.usec.com 23-05-2007 15:12 >>>
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