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]