Subtract Now() - 6 months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the DateAdd function

DateAdd("m",-6,Date())

will give you the date six months prior to today's date.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
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
Click to expand...

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]
 
Back
Top