Date Code for 180 reminder

  • Thread starter Thread starter RDVS
  • Start date Start date
R

RDVS

I have a database using access that presently takes an input date
(MaxOfDates) and creates a reminder for the next quarter and the quarter
after. Can't remmeber how to modify it because after using it for some time,
this requirement has changed.

This is the code in use:
Ground Egress due Date:
DateSerial(Year([MaxOfDates]),((Month([MaxOfDates])-1)\3)*3+4,1)

How do I modify the code to reflect the MaxOfDates plus 180 from that date?
 
That depends. if the 6 months is exactly 6 months or a true 180 days. It
must be 180 days beyond, reflecting the various days/month
 
RDVS said:
That depends. if the 6 months is exactly 6 months or a true 180 days. It
must be 180 days beyond, reflecting the various days/month
Click to expand...

If you want exactly 180 days, not 6 months, then use

DateAdd("d",180,[MaxOfDates])
 
Back
Top