Question

6
Replies
450
Views
Close popover
Abhishek Singh (AbhishekS6618)
Genpact

Genpact
IN
AbhishekS6618 Member since 2020 5 posts
Genpact
Posted: April 26, 2020
Last activity: June 1, 2020

Date Format Issue in Report Definition

Hello All,

I have a Report Definition which has pxUPdateDateTime as a Column. When I run this RD I can see the value in this format: 29/01/2020 08:46

However, when I use this Report as a source in my Data Page I get the value as in this format:

20200129T134646.039 GMT

Also, when I download Excel using Export to Excel(which uses the same report) the date comes in below format.

20200129T134646.039 GMT

How can I get Data in Excel in below format:

29/01/2020 08:46

I have tried using Export_DateTime HTML to provide custom format but that didnt work.

I am using MSOGenerateExcelFile Activity.

 

***Edited by Moderator Marissa to update Platform Capability tags****

Reporting