Skip to Content
0
Former Member
Dec 05, 2007 at 05:51 AM

Reports Greater Than 30 Days

643 Views

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