Subtract Month

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

Guest

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?
 
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 - return maximum date 1
Chg "day" portion of DateAdd Date 3
Text to Date conversion 3
Calculating Period and Cumulative values... 5
Subtracting a query result from a constant. 1
IIF update query with Between Criteria 5
Select End of Month records 2
Aggregate function 2

Back
Top