Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date to Year conversion

Status
Not open for further replies.

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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top