Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create an expression showing my open tickets that have been open for greater than or equal to 60 days.
My Date field is Date_Created. With the following expression my result comes back as '0'
=Count({<Date_Created={">=$(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)
Try
=Count({<Date_Created={">=$(=Date(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)
Regards,
Antonio
Try
=Count({<Date_Created={">=$(=Date(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)
Regards,
Antonio
Or this:
=Count({<Date_Created={"$(='>=' & Max(Date_Created)-60))"}, State-={'Closed'}>}Incident#)