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

  • Thread starter Thread starter tlyczko
  • Start date Start date
T

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
 
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
Click to expand...

Between DateSerial(Year(Date())-1,12,1) and Date()
 
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
 
Back
Top