DateAdd problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a button that sets the date in a text field 2 years from
another date text field using the setvalue macro. Problem is I want the date
to be 2 years minus one day not 2 years exactly.
DateAdd("m",24,[Forms]![Form Licence Application]![Valid From])

How do I subtract the day?
 
Just substract 1:
DateAdd("m",24,[Forms]![Form Licence Application]![Valid From]) - 1

HTH
 
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

DateAdd in calculated field 3
Hello happy new year to all, Text box input for year of purchase 0
Case Select not working in 2007 14
Changing Time using a macro 1
DateAdd and DateSerial problem with months and days 2
Help with code. 4
DateAdd function in default value 3
how to add date if 1

Back
Top