Duration field to display only number of days
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2024 10:17 PM
Hi All,
I want to create a report for the Incident table where I want the field Same Day Closure (It must calculate the difference between the closed time and the opened time) it must return the value in the form of Days only. Now the output is coming in the form of DD-HH-MM. Please help me solve this issue.
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2024 04:41 AM
AG,
"max_units = Days" in the Attributes field does not change the field value in anyway. It's still D:H:M:S.
Interestingly, "max_unit=minutes" does provide a field value readout in minutes.