Subtract Month

T

Tandy

Hi! I have a field in my query called DateRateAssigned. I would like the
next field to be DateRateAssigned minus one month. Right now if
DateRateAssigned is 1/1/2005 and in the next field I put in
"DateRateAssigned-1" I get 12/31/2004 instead of 12/31/2004. How do I
subtract a whole month?
 
R

Rick Brandt

Tandy said:
Hi! I have a field in my query called DateRateAssigned. I would
like the next field to be DateRateAssigned minus one month. Right now
if DateRateAssigned is 1/1/2005 and in the next field I put in
"DateRateAssigned-1" I get 12/31/2004 instead of 12/31/2004. How do I
subtract a whole month?
Click to expand...

DateAdd("m", -1, [YourDateField])
 
Top