In 6.1, i have a report definition where the data will be exported to an excel using the OOTB activity. when i try to open the excel file which got attached to the WO, i see amount field in text format. and no comma for thousand saperator.
Ex: OOTB date property(i.e. Lets say OriginalDate) will be displayed as 20160202T213400.000 GMT in clipboard. If you want to format this to 2016/02/02, create a text property (i.e. lets say FormattedDate) & then use functions in data transform(DT) rule to set formatted date to this. In DT rule, use set method. i.e.
Set FormattedDate= @DateTime.FormatDateTime(OriginalDate,"yyyy/MM/dd",null,null).
Try same for currency also.
Hope this will solve your problem.
Posted: 4 years ago
Posted: 11 Apr 2018 23:59 EDT
Rincy Rappai (RINCYRAPPAI)
Principal Software Engineer DevSecOps, Application Security