Query for current year dates plus December of previous year??

[tlyczko]

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

 

[fredg]

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()

 

[tlyczko]

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