Subtracting months from a date in Query

[rynorem]

I have a field called DATE_END_DEERS which is in a format of YYYYMMDD (20060530). I need to run a query that shows 6 months subtracted from this date. I can never get an answer that is even close. Can someone please help? ACCESS2000.

 

[KenHigg]

Have you simply tried to subtract 182 days from the date? Would that work?

 

[rynorem]

How, Ken? Is it a DateAdd script?

 

[selenau837]

I have a field called DATE_END_DEERS which is in a format of YYYYMMDD (20060530). I need to run a query that shows 6 months subtracted from this date. I can never get an answer that is even close. Can someone please help? ACCESS2000.

DateAdd("m",-6,[DATE_END_DEERS])


The above DateAdd fuction will subtract 6 months from that field.

Add a field called

NewDate:DateAdd("m",-6,[DATE_END_DEERS])

to your query.
That should show you the date you want after the 6 months is subtracted.