Access 2000 - changing dates

T

trainerab

Any suggestions on how to get the YEAR of a dd/mm/yy field
to be updated to current year? e.g. 01/01/03 to be
displayed as 01/01/04 etc?
Many thanks
 
B

Beth Melton

What are you trying to do?

Are you trying to update a previously stored date field? If that is
the case then you can use an Update query and the DateAdd function.

If you need more specifics then we will need additional information
such as exactly what you are trying to accomplish. :)

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
D

David

trainerab said:
Any suggestions on how to get the YEAR of a dd/mm/yy field
to be updated to current year? e.g. 01/01/03 to be
displayed as 01/01/04 etc?
Click to expand...


The current year is 04???

My, I must have slept well last night!!!

David
 
Top