This post is more than 5 years old
2 Intern
•
243 Posts
0
2693
January 28th, 2011 06:00
Units of a duration
Is there any way to set this? I would like to have retention times displayed as months rather than "4 weeks and 2 days" etc.
No Events found!
This post is more than 5 years old
2 Intern
•
243 Posts
0
2693
January 28th, 2011 06:00
Is there any way to set this? I would like to have retention times displayed as months rather than "4 weeks and 2 days" etc.
Top
David_Hampson_90e289
2 Intern
•
243 Posts
0
February 4th, 2011 00:00
As you say I can only amend it to weeks or less in the report. I worked around this by dividing the duration by the average number of seconds in a month and converting to integer.
David_Hampson_90e289
2 Intern
•
243 Posts
0
January 28th, 2011 07:00
One further point, I notice there is some variation in retention - for example some month retentions show as "4 weeks 2 days" and some as "4 weeks 3 days for example". I assume this must be down to the value being derived from subtracting the backup time from the retention time instead of taking the value configured in the schedule....?
ian.richardson-1
5 Posts
0
February 3rd, 2011 14:00
Hi David,
When you have the report open you should be able to bring down the top bar, click on the yellow table data button and then on the field you want to change you can change the "Scale to" setting but the highest you seem to be able to set it to is weeks which is what you already have.
Thanks,
I.
user_rm
2 Posts
0
February 27th, 2018 11:00
I have a similar need to display duration in Hours format (e.g. 1.5 Hour). How to go about doing that?