Between 2 dates

  • Thread starter Thread starter QB
  • Start date Start date
Q

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
 
Back
Top