Subtract Now() - 6 months
On Tue, 20 Feb 2007 13:45:13 -0800, Tony Ramirez
wrote:
Help please. Would like to take Expr2: Now() - Value
Value would be 6 for six months.
Like the result written in regular Date Time.
Thanks,
Tony
The DateAdd() function will do this for you:
DateAdd("m", -[Value], Date())
I'd use Date() rather than Now() because Now() returns the current
date and time, accurate to a few microseconds; you probably don't need
that level of precision for six months ago!
John W. Vinson [MVP]
|