Date Code for 180 reminder

[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?

 

[RDVS]

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

 

[Dirk Goldgar]

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

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

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

 

[RDVS]

Perfect, Thanks for the thought.