Automating Dates

[Guest]

Hi

I have a load pf records that were created in another database that i have
imported into my current database. I my current database i have coding in
place to automatically add 3,6,or 12 months to the service date giving the
next service date, which works fine for any new records add on my database.
I don't know how to get the next service date on the records created before
this database. Dose anyone know how i can do this without having to go back
through them all one by one coz theres 1600 of them. They came from a
Goldmine database - converted into excel and then imported into access. In
Excel i had used add 90, 180 and 365 days to fill in the next service date
but some records were showing the wrong date cox they were going by day and
not month. I need them running by month.

Natasha

 

[Arvin Meyer [MVP]]

Use the DateAdd() function in an Update query. First make a select query to
get all the records you want to change to 3 months. Then run the query and
do the 6 month, then the 9 month. The DateAdd function for 3 month would
look like:

DateAdd("m",3,[DateFieldName])