topic Re: Set expression using Now() in App Development

Set expression using Now()

materi — Tue, 17 Sep 2019 07:05:04 GMT

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 — Tue, 17 Sep 2019 07:13:09 GMT

try to use this:

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

Mauritz_SA — Tue, 17 Sep 2019 07:20:34 GMT

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 — Tue, 17 Sep 2019 07:21:28 GMT

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