Question

9
Replies
3085
Views
Giridhar_Metikal Member since 2014 95 posts
Instellars Global Consulting
Posted: December 7, 2017
Last activity: January 11, 2019
Closed

Date Format is showing incorrect format in Excel file on Pega's "Export to Excel"

Hi All,

I've a report definition where one of the columns is a text column containing "Date" content in "dd-Mon-yyyy" format. Business reported the issue saying the column data is not properly sorted as it is sorting based on the text but not on the latest date values. This is expected.

To fix this, we've referred a function alias rule which will convert text to date format and is showing appropriately on viewing the report in the application. However, it is showing in "dd/mm/yyyy" format in the downloaded excel on click of Pega's "Export to Excel".

I am using Pega 7.2.2. Can somebody help me how to fix this?

Thanks in advance.

Regards,

Giridhar Metikal

Reporting
Moderation Team has archived post
Share this page LinkedIn