How do I get the Date 5 Months from Now in access
There is no reason to use Now() if you're operating on dates only. Use Date() in all cases unless you actually need the time component returned by Now(). Given that running DateAdd ("m", 5, Now()) will not return the same result if you run it five minutes from now, but DateAdd ("m", 5, Date()) *will* give you the same result (unless midnight passed in between the two calls), I can't see any justification for using Now() in this context.
David-W-Fenton
2010-04-21 20:16:05
A:
Take Andomar's answer, but here is a dumber solution:
Future: Date()+((365/12)*5)
The result is somewhat different, and I post it only in case the result is somehow closer to what you need.
Smandoli
2010-04-21 18:32:14
@Smandoli Just curious ... if you're going that route, why not (365.25 / 12)?
HansUp
2010-04-21 18:37:49
Either ignorance or carelessness ... darn it, I think it's carelessness. Thanks for the tip.
Smandoli
2010-04-21 19:26:36
OK. Seems like maybe you're interested in not just the date, but also time of day. If so, consider Now()+((365.25/12)*5)
HansUp
2010-04-21 19:35:58
What a terrible suggestion. Its results don't correspond to the calendar or to any human definition of "5 months".
David-W-Fenton
2010-04-21 20:14:14