Inquiry around Now() and comparing with less than/greater than

[Christopher_Lawrence]

Im looking to understand how to properly set up a set analysis expression that takes a date field and compares it to the Now() function. I.e, if the date in question is greater than now(), include it towards the count formula I have. (I want to use now() opposed to today() as the time stamp is provided, which my date field provides the results in yyyy-dd-mm hh:mm:ss). I have attempted it, but the set up seems to be rather confusing to me.

Any insight would be much appreciated!

[QFabian]

Hi @Christopher_Lawrence , please think on dates with time as numbers with decimals.

So, yo can create an expression like this :

count({< Date_Field = {"> $(=num(now()))"} > } Date_Field)

or like this, without set analysis

count(if(Date_Field >= now(), Date_Field))

[Kashyap_R]

Hi

count({< Date_Field = {"> $(=Date(now(),'yyyy-dd-mm hh:mm:ss'))"} > } Date_Field)

hope this helps

Thanks and regards

kashyap.R