Adding a one year to a date

R

Rick Brandt

Mike said:
Does anyone know how you can add a one year to a date using a query ?
Click to expand...

NextYear: DateAdd("yyyy", 1,[DateField])

or

NextYear: DateSerial(Year([DateField])+1, Month([DateField]), Day([DateField]))
 
M

Mike

Thank You

Rick Brandt said:
Mike said:
Does anyone know how you can add a one year to a date using a query ?
Click to expand...

NextYear: DateAdd("yyyy", 1,[DateField])

or

NextYear: DateSerial(Year([DateField])+1, Month([DateField]), Day([DateField]))
Click to expand...
 

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

Send meeting request for different dates (no repetition) to different people 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Mail Merge skipping records/sending one at a time 0
Autofill Date in Word 15.33 for Mac 0
Images are pixelated when saving to PDF 0
Display weeks from a Milestone 0
How show deathdates, anniversaries,etc so as to repeat each year 0
Making "Change Highlighting" feature darker 1

Top