Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
Count(if(LateDate>Now(),Ticket_ID))
Hi
try to use this:
Count({$<LateDate={$(=Now())}>}Ticket_ID)
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
Count(if(LateDate>Now(),Ticket_ID))