Compare this month's sales to this month last year

[annsolomon]

I'm trying to compare invoices generated in May of 2002 to invoices generated in May of 2003 so we can see how much money we made compared to last year at this time.

I've tried datediff, dateserial, dateadd but can't seem to get it right. Can some kind soul give me a hand here?

Ann

 

[annsolomon]

I figured it out. Had to use "between". I was trying to just hone in on a particular month last year but I guess that was the lazy way out. Anyway, here's what I ended up with to compare May 02 to May 03:

Between DateSerial(Year(Date())-1,Month(Date())-1,1) And DateSerial(Year(Date())-1,Month(Date()),1)-1

Ann