Export to Excel - Date and Time component of a DateTime property to be shown in 2 separate columns
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.
We need help in figuring out how we can display Date and Time component of a DateTime property under 2 separate columns in Excel.