HELP!! Subtracting 6 months from a date field.

  • Thread starter Kath via AccessMonster.com
  • Start date
K

Kath via AccessMonster.com

Hello all,
I have tried the following and it does not work:
<=DateAdd("m",-6,[MONTHLY IMPORTS].[DATEENT])

I am trying to exclude any records that are older than 6 months prior to the
date of entry (DATEENT).

Any suggestions?

Thanks!
 
F

fredg

Hello all,
I have tried the following and it does not work:
<=DateAdd("m",-6,[MONTHLY IMPORTS].[DATEENT])

I am trying to exclude any records that are older than 6 months prior to the
date of entry (DATEENT).

Any suggestions?

Thanks
Click to expand...

Then don't you want > (greater than) as criteria?
DateAdd("m",-6,[DATEENT])
Click to expand...
 
K

Kath via AccessMonster.com

Yes, I suppose that I would but it still does not work. It does not exclude
any of the records when I use the >, and when I use the < it actually exclues
all of them? I am confused. :{
 
K

Kath via AccessMonster.com

I am a dork. I figured it out. I had to use a combined field expression on
the dates to get the results needed. :)
 
Top