[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Add years to a date field through an update query

Good Day All, I have converted a dBase IV database that has some old employee absences data. The data is pre 2000, and I want to add a number of years to the date field to bring me out of the stone ages. I want to do this through an update query, but I have not been successful.

Any suggestions would be greatly appreciated. I am using Windows XP and Access 2002 in 2000 mode.

Thanks in advance,

David
0
yddadsjd95
Asked:
yddadsjd95
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
are you aware for the DATEADD("yyyy", 2000, yourdatefield)   to add 2000 years to the date field value...
assuming of course that the field is indeed datetime...
0
 
yddadsjd95Author Commented:
I wasn't, but I am now :o). Thanks Angel for coming to my rescue and taking time out of your busy, busy day (I read your profile) to assist me.

Have a blessed day as you have blessed mine.

David
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now