Question

6
Replies
169
Views
AbhishekS6618 Member since 2020 4 posts
Genpact
Posted: 5 months ago
Last activity: 4 months 2 weeks ago

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
Share this page LinkedIn