Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to set up a count for events that has been in the status draft for more than 3 days. I have setup the following:
count ({<[Events: Incident Status]={'Draft'}>} isEvent and (Date(Now()))-([Events: Date occurred])>3)
but it only takes the first part in the counting (counts all events in draft) and not only the events in draft for more than 3 days.
Please help
Hi @MonikaF,
Check this one:
count({<[Events: Incident Status]={'Draft'}, [Events: Date occurred]={"<$(=Date(Today()-3))"}>} isEvent)
** When applicable please mark the correct/appropriate replies as "solution". Please LIKE threads if the provided solution is helpful to. **
Hi @MonikaF,
Check this one:
count({<[Events: Incident Status]={'Draft'}, [Events: Date occurred]={"<$(=Date(Today()-3))"}>} isEvent)
** When applicable please mark the correct/appropriate replies as "solution". Please LIKE threads if the provided solution is helpful to. **