I need to display the number of problem tickets that are more than 30 days open based on the date created. and calculate the number of open problem tickets more than 30 days. So far the formula I have is:
if {table.datecreated} > Date (30) Then
Sum ({table.status}, {table.itemnumber})
Am I on the right track? Any ideas? I am having trouble with the date functions in the formula workshop. The reading materials have all lead me to a dead end.
Thanks,
ITSteveSE