Giridhar Metikal (Giridhar_Metikal)
Instellars Global Consulting
Instellars Global Consulting
Giridhar_Metikal Member since 2014 95 posts
Instellars Global Consulting
Posted: December 7, 2017
Last activity: January 11, 2019
Posted: 7 Dec 2017 8:47 EST
Last activity: 11 Jan 2019 2:09 EST

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.


Giridhar Metikal

Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.