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
..

"Tony Ramirez" wrote in message
...
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