Jul 8, 2010 #1 ocan Programmer Jun 28, 2004 31 US In a query I have a date field with dates(ie.7/7/2010). How can I build an expression that converts the dates to just the year?
In a query I have a date field with dates(ie.7/7/2010). How can I build an expression that converts the dates to just the year?
Jul 8, 2010 #2 randy700 Programmer Sep 25, 2003 2,384 US Something like this? Year(DateField) As MyYear Randy Upvote 0 Downvote