Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to display whole number in date format in FR Studio

User_OV3T9Jul 22 2015 — edited Jul 22 2015

In a report I am creating in FR Studio, I am including an employee start date account that gives the exact date an employee was hired.  When I render the report, the start dates are appearing as whole numbers (ex 20,150,722 instead of 07/22/2015). In workspace I have the account set as "Date" data type, and in my preferences under financial reporting I have the "Date Value Format" set as MM/dd/yyyy.  However, when I render the report, it is still appearing as a whole number.  Is there a way to fix this?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2015
Added on Jul 22 2015
2 comments
850 views