Conditional count on date field

[Payman]

Hi,

We have a date field with this format '2019-04-28 04:45:01.000'. Want to count the IDs where the date is equal to today's date. I used the below one but it is not true:

=Count(If(Date(CreateDate,'YYYY/MM/DD')=Date(Today(),'YYYY/MM/DD'),ID))

[Vegar · Accepted solution]

Try this expression:
Count({<CreateDate={">=$(=daystart(today()))<=$(=dayend(today()))"}>} ID)