Between 2 dates

[QB]

I am trying to build a WHERE criteria for a query and am having trouble that
I hope someone can help me with

What I am looking to do is limit the date from the first of the current year
to today. So I tried

WHERE DtAct Between #1/1/Year(Date())# AND date()

but this does not work. What would be the proper way to handle this scenario?

Thank you,

QB

 

[QB]

Got it working!

WHERE DtAct Between cdate("1/1/" & Year(Date())) AND date()

 

[Douglas J. Steele]

Or

WHERE DtAct Between DateSerial(Year(Date()), 1, 1) AND date()