Set Analysis in Expression to show open tickets 60 days or greater

[#1]

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#)

[antoniotiman · Accepted solution]

Try

=Count({<Date_Created={">=$(=Date(Max(Date_Created)-60))"},State-={'Closed'}>}Incident#)

Regards,

Antonio

[sunny_talwar]

Or this:

=Count({<Date_Created={"$(='>=' & Max(Date_Created)-60))"}, State-={'Closed'}>}Incident#)