Question

5
Replies
615
Views
_BharathKumar88 Member since 2016 11 posts
HCL
Posted: 3 years ago
Last activity: 3 years 4 months ago
Closed

Export to Excel - Date and Time component of a DateTime property to be shown in 2 separate columns

Issue Description:

We have a requirement to show Date and Time seperately in 2 columns for a DateTime property.

In Section we are using repeating grid layout and using DateTime format accordingly to show Date and Time component of DateTime property seperately in 2 columns.

We need to export this data to Excel. We are using OOTB activity pzRDExportWrapper to export the data using Report Definition. If we are using DateTime property in RD it will show date and time both in excel.

Help Needed:

We need help in figuring out how we can display Date and Time component of a DateTime property under 2 separate columns in Excel.

Reporting
Moderation Team has archived post
Share this page LinkedIn