Calculating next date

  • Thread starter Thread starter Grinner
  • Start date Start date
G

Grinner

Help please
I have a scheduling database but don't know how to get the next date while
keeping the previous.

EG Need today's date as start, item will be scheduled for 3 weekly
inspection, need to find next day but also need to search when last done
(1,2,3 ect times ago) or what dates over the next year??

Appreciate assistance
Grinner
 
Help please
I have a scheduling database but don't know how to get the next date while
keeping the previous.

EG Need today's date as start, item will be scheduled for 3 weekly
inspection, need to find next day but also need to search when last done
(1,2,3 ect times ago) or what dates over the next year??

Appreciate assistance
Grinner
Click to expand...

You can use the DateAdd function to find dates in the future (or past)
using your current date as a starting point:
7 days in the future from a date:
=DateAdd("d",7,[DateField])

7 days in the past from a date:
=DateAdd("d",-7,[DateField])

or = DateAdd("ww",1,[DateField]) for weeks, etc.

You can substitute Date() for [DateField] if you want it based upon
the current date instead of a stored date value.

Look up the DateAdd function in VBA help files for the other time
period arguments.
 
Back
Top