Set expression using Now()

[materi]

I am trying to eliminate all Ticket_ID data where the latedate has been passed. Why doesn't the expression below work:

Count({$<LateDate>{Now()}>}Ticket_ID)

[StarinieriG · Accepted solution]

Hi

try to use this:

Count({$<LateDate={$(=Now())}>}Ticket_ID)

[Mauritz_SA · Accepted solution]

Hi Materi

You cannot use greater than (>) in a set expression directly. You have to specify a condition that has to be satisfied. The following should work:

Count({$<LateDate={">$(=Now(1))"}>}Ticket_ID)

Regards,

Mauritz

[asinha1991 · Accepted solution]

Count(if(LateDate>Now(),Ticket_ID))