I need help with a formula calculating past due dates based on a field
if ({S_EVT.DUE_DT}) < currentdate-60 then "Past Due By 60 Days"
else if ({S_EVT.DUE_DT}) < currentdate-90 then "Past Due By 90 Days"
The first part is working good, but the 90 day part isn't. I beleive it has to determine a range between 61 and 90, but I am kind of stuck there.
Any help is appreciated.
if ({S_EVT.DUE_DT}) < currentdate-60 then "Past Due By 60 Days"
else if ({S_EVT.DUE_DT}) < currentdate-90 then "Past Due By 90 Days"
The first part is working good, but the 90 day part isn't. I beleive it has to determine a range between 61 and 90, but I am kind of stuck there.
Any help is appreciated.