Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Age calculation when exporting Service Desk reports

Created: 11 Feb 2011 | 4 comments
yabru's picture
1 Agree
0 Disagree
+1 1 Vote
Login to vote

By default, in both SD 7.0 and 7.1, when you export or email a report in Excel, it will show the (Age) as the actual Time and Date, rather than the Age.

When viewing the report in the Service Desk console, the Age shows correctly as 3 days or 5 days 2 hours, this format should be kept when exporting the same report to Excel.

The only way around this now, is to export the sql code, then create new a report with that code and add the DateDiff syntax....which is way too much effort for the price and advanced nature of this product.

Please can we introduce this small yet very helpfull feature....like soon!  :-)

Comments 4 CommentsJump to latest comment

yabru's picture

How are you guys exporting your reports to discuss with your Management team???

0
Login to vote
Deep Green's picture

This is a good pickup as we had the same problem. 

We did use the export SQL code method but we used the Symantec delivered function dbo.GetAgeDescription instead of DateDiff which makes it a lot easier

0
Login to vote
rickss38's picture

I just found the same issue, has this been resolved? 

0
Login to vote
TGiles's picture

Exporting reports to Excel that contain the Age Description field produces the same out put in the Excel file as the report shows in the portal in 7.5. 

0
Login to vote