Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Payman
Contributor
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
Vegar
MVP
MVP

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

View solution in original post

1 Reply
Vegar
MVP
MVP

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