Date using (+,_)keys

  • Thread starter Thread starter Steve Warren
  • Start date Start date
S

Steve Warren

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

Thank you
 
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 -
 
Back
Top