Question
Data Type export of DateTime properties
We are trying to export the data table which has DateTime property. So that users can add data to it, but when its being exported the yyyyMMddThhmmss.000GMT. This is not that much understandable by business, is there a way to format it into a more user friendly format so that the export to excel (csv) will have the text in the required format.
***Updated by Moderator: Vidyaranjan. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option***
Hi Imran,
I guess it's possible by adding an inline style-sheet in the DateTime property, which you intend to export.
Add any of the below format based on your requirement in the inline style sheet:-
@(Pega-RULES:DateTime).DateTimeDifference(@(Pega-RULES:String).toDate(Param.Input),@(Pega-RULES:String).toDate("20160621"), "D")
@(Pega-RULES:String).substring( @(Pega-RULES:DateTime).CurrentDateTime(), 0, 4)+"0101"
As inline style in the cell of the input field to ensure that in excel sheet text format remains same as in section rule.
Or else, you can alter the "ExportToExcel" activity and call a data transform to iterate over the particular DateTime property to change the format of the property.