I have an issue with my function: =DCount("*","ReworkSearchQ","ReworkDate >= DateSerial(Year(Date()),1,1)  AND < DateSerial(Year(Date()),2,1)")
I'm using this as the control source for an unbound text box on a form but it just gives an #ERROR message.  However, if you remove the inequalities and use the BETWEEN keyword, then it works, but this isn't what I need.  I need just the dates for January.  If I put the where condition part of this in the criteria section of a query, it works then.  Can you please tell me what I'm doing wrong?  Thank you very much!

---

Reply from Alex Hedley:

Original
=DCount("*","ReworkSearchQ","ReworkDate >= DateSerial(Year(Date()),1,1) AND < DateSerial(Year(Date()),2,1)")

I think you're missing what you are comparing on the second check, try adding the Field "ReworkDate" before the "<"

New
=DCount("*","ReworkSearchQ","ReworkDate >= DateSerial(Year(Date()),1,1) AND ReworkDate < DateSerial(Year(Date()),2,1)")

You might also need to wrap the dates in "#"s.
MyDate >= #10/30/2016# And MyDate < #11/30/2016#