Developer Forum

Hello,

I have a db app where sometimes during January, people need to look at
the previous year's data, going back through December.

How do I construct a query which says: "Give me all this year's dates
plus last December's dates." always for the current year??

I think it would involve DateSerial, but I am not sure how to get the
December part...

Thank you, Tom

Between DateSerial(Year(Date())-1,12,1) and Date()
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thank you, I had also figured it out using the Year and Month functions
too, your solution is more simple and elegant.

Thank you, Tom