S
Steve Warren
What code can i use to increase and decrease a date field using the plus &
minus keys?
Thank you
minus keys?
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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 -
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 -
F
Fred Boer
Dear Steve:
You might find what you need here:
http://www.mvps.org/access/forms/frm0041.htm
HTH
Fred Boer
You might find what you need here:
http://www.mvps.org/access/forms/frm0041.htm
HTH
Fred Boer