Modify a group of date fields

  • Thread starter Thread starter Dave B.
  • Start date Start date
D

Dave B.

Is there an easy way to advance a bunch of date entries in a column by a
period of months?
 
Use the DateAdd function to return a value however many months after the
current value and update the value to that in an update query, e.g. to update
all dates by 3 months:

UPDATE MyTable
SET MyDate = DateAdd("m",3,MyDate)
WHERE MyDate IS NOT NULL;

Ken Sheridan
Stafford, England
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date search query 0
Excel Vba to change displayed year automatically. 14
Validation rule build on other field in the same table 5
Query to sum between specific date And Date() 0
Date Range Query Problem 20
Using DateAdd and IIF conditions in a Query 2
Show null values in Query 0
Form field lookups to next record-compex 0

Back
Top