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!

Register Log in
  • Congratulations Rhinorhino 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

ocan

Programmer
Joined
Jun 28, 2004
Messages
31
Location
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?
 
Sort by date Sort by votes

Something like this?
Year(DateField) As MyYear


Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question Question
Can Access be used to generate and respond to text messages?
Replies
6
Views
6K
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Locked
  • Question Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
YoBi4Ever
  • Locked
  • Question Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
630
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them?
2
Replies
22
Views
9K
Andrzejek
Andrzejek
lmcate
  • Locked
  • Question Question
How to Open ACCESS (MDB) from an HTML Page
Replies
2
Views
5K
lmcate
lmcate

Part and Inventory Search

Sponsor

Back
Top