Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
Payman
New Contributor

Conditional count on date field

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))

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Conditional count on date field

Try this expression:
Count({<CreateDate={">=$(=daystart(today()))<=$(=dayend(today()))"}>} ID)
Please ekskuse my Norglish and Swenglish typos.
1 Reply
Partner
Partner

Re: Conditional count on date field

Try this expression:
Count({<CreateDate={">=$(=daystart(today()))<=$(=dayend(today()))"}>} ID)
Please ekskuse my Norglish and Swenglish typos.