This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Smart Reporting Remedy
9.1.04 versions and below
- Why date outputs are not getting displayed on a report if used in a CASE statement output?
When you use a case statement any date field gets transformed to the raw value that is on the database, in this case an Epoch date, in fact if column format gets changed to "Raw Formatter" the Epoch numbers will be displayed.
- 18.05 and above versions this is working fine.
- There is a workaround on lower versions, refer to the file attached.