Comparing dates in Set Analysis

[neerajthakur]

How can I get count of IDs where Date is more than Today.

count({<num(trainingdate)>Today()>} distinct id)

[Iswarya_]

Hi @neerajthakur 

Count({$<trainingdate={">$(=date(Today(),'YYYY-MM-DD'))"} >} distinct id)

and make sure that the trainingdate field format matches the format of your formatted today's date

[neerajthakur]

I tried but I am getting this error.

[Iswarya_]

Can you try by adding one more bracket ')'

Count({$<trainingdate={">$(=date(Today(),'YYYY-MM-DD'))"} >} distinct id)

[Iswarya_]

If the issue is solved please mark the answer with Accept as Solution

[neerajthakur]

Count({<$<expirydate={">$(=date(Today(),'YYYY-MM-DD'))"}>} distinct [Ref ID])

It isn't resolved getting set modifier error.

[Iswarya_]

Please remove one '<' before the expirydate field.

Try like below:

Count({$<expirydate={">$(=date(Today(),'YYYY-MM-DD'))"}>} distinct [Ref ID])

[neerajthakur]

How can I include a flag in this statement like Flag={'1'}

[Iswarya_ · Accepted solution]

Count({$<expirydate={">$(=date(Today(),'YYYY-MM-DD'))"},Flag={1}>} distinct [Ref ID])

[Iswarya_ · Accepted solution]

Count({$<expirydate={">$(=date(Today(),'YYYY-MM-DD'))"},Flag={1}>} distinct [Ref ID])