Looking for formula confirmation

[stapuff]

I wrote the following and it appears to be giving me the correct result, but.................

My criteria = I want to see all the results from (Current Month - 2) to Today. (5/1/2007 - Today)

Between DateSerial(Year(Now()),Month(Now())-2,1) And DateSerial(Year(Now()),Month(Now())+1,0)

Looking for someone to confirm or suggest.

Thanks,

Kurt

 

[Norie]

Kurt

You'd probably be better of using DateDiff and Today.

I don't quite understand how the second DateSerial would return today's date, if that's what it's supposed to do.

 

[stapuff]

Norie -
You are correct. I posted
"My criteria = I want to see all the results from (Current Month - 2) to Today. (5/1/2007 - Today)"

When I should have posted
"My criteria = I want to see all the results for the previous 2 months through Today. (5/1/2007 - Today)"

 

[NumbersMax]

Many ways to skin a cat...

How about the Dateadd/DateSerial in conjuction?

Between
Dateadd("m", -2, DateSerial(Year(Now),Month(Now),1))
and
Now()

I added your expression to a query and it worked just fine the way it was. Mine also worked, but it's not like I put either through a lot of testing to see if there were any loopholes!

Max