Date using (+,_)keys

[Steve Warren]

What code can i use to increase and decrease a date field using the plus &
minus keys?

Thank you

 

[Guest]

You can write for example date()+1 will return the date of tomorow, the date
field + or - will add or substruct the date by days.
But why not use the function dateadd
e.g
=dateadd("d",2,date()) - will return the date + 2 days
=dateadd("d",-2,date()) will return the date - 2 days
=dateadd("m",2, date()) will return the date + 2 month
etc, check help on the subject, its better then using + and -

 

[Fred Boer]

Dear Steve:

You might find what you need here:

http://www.mvps.org/access/forms/frm0041.htm

HTH
Fred Boer