Adding a one year to a date

  • Thread starter Thread starter Mike
  • Start date Start date
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]))
 
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...
 
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

Add one year in second combobox in vba 0
Same date (today) each year 1
Hello happy new year to all, Text box input for year of purchase 0
Excel Vba to change displayed year automatically. 14
Year Comparison Report 6
Adding Years to a Date 4
Year-over-Year Comparisons 1
Access 2 Digit year in Access Text Box 3

Back
Top