https://community.qlik.com/t5/QlikView/Conditional-count-on-date-field/m-p/1576616#M741535 Try this expression:<BR />Count({&lt;CreateDate={"&gt;=$(=daystart(today()))&lt;=$(=dayend(today()))"}&gt;} ID) Sat, 04 May 2019 21:23:20 GMT Vegar 2019-05-04T21:23:20Z https://community.qlik.com/t5/QlikView/Conditional-count-on-date-field/m-p/1576615#M741534 <P>Hi,</P><P>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:</P><P>=Count(If(Date(CreateDate,'YYYY/MM/DD')=Date(Today(),'YYYY/MM/DD'),ID))</P> Sat, 16 Nov 2024 03:40:37 GMT https://community.qlik.com/t5/QlikView/Conditional-count-on-date-field/m-p/1576615#M741534 Payman 2024-11-16T03:40:37Z https://community.qlik.com/t5/QlikView/Conditional-count-on-date-field/m-p/1576616#M741535 Try this expression:<BR />Count({&lt;CreateDate={"&gt;=$(=daystart(today()))&lt;=$(=dayend(today()))"}&gt;} ID) Sat, 04 May 2019 21:23:20 GMT https://community.qlik.com/t5/QlikView/Conditional-count-on-date-field/m-p/1576616#M741535 Vegar 2019-05-04T21:23:20Z