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

 

[LxQ]

this seems to work well unless you're in January, and the Year(Now()) function will mess you up if you're looking for a prior year month.

 

[VicRauch]

You say you want the "To" date to be 5/1/07 because that is Today. But your expression gives the last day of the current month. Do you want it to be Today, or the last day of the current month? For Today, all you need would be Date() rather than going through the DateSerial function.

When I looked at your expression, I agreed with LxQ. But then I tested it, and found that in January of 2007, by subtracting 2 from the 1 for January, I ended up in Nov 1, 2006. So DateSerial will take the -1 for a month in 2007 and give you the correct month and year. VERY NICE job from Microsoft. Would not have believed it if I had not seen it.