Question
Sberbank
UA
Last activity: 3 Apr 2018 11:13 EDT
How to get a formatted date in a xlsx file?
I use the MSOGenerateExcelFile activity to get a xlsx documentv from a bunch of specific data. The document contains a Date type property among others, and I would like to get it in the document as "dd.MM.yyyy", but I get 20180111T183143.269 GMT instead.
I have already performed:
1) https://community.pega.com/support/support-articles/export-excel-date-format-inconsistently-mm-dd-yyyy
It doesn't work for me, but I may do something wrong.
2) I tried to format the exact cell as Date in Excel, but it doesn't help
3) Tried to override the activity, but it maps data on a template implicitly, and I'm not able to update the code.
Anybody knows how to format the data for my excel document? Please, share it with me.
Thank you.
***Edited by moderator, Maryrita: moved to Product Support from Pega Academy***
***Edited by Moderator Marissa to update categories***
Accepted Solution
Pegasystems Inc.
US
Depending on what you are doing and where, if you can get to a point where you can step into an expression builder and transform your property, you should be able to transform your date like the following.
FormatDateTime(.your_DATE,"dd.MM.yyyy","America/New_York","en_US")
Pegasystems Inc.
US
Hello,
Seeing your issue is not part of a Pega Academy course I will transfer this post to our Product Support Community to assist.
Thanks
Accepted Solution
Pegasystems Inc.
US
Depending on what you are doing and where, if you can get to a point where you can step into an expression builder and transform your property, you should be able to transform your date like the following.
FormatDateTime(.your_DATE,"dd.MM.yyyy","America/New_York","en_US")
Sberbank
UA
Hello. I created an additional text property and just save date in appropriate format using @DateTime.FormatDateTime(.pxCreateDateTime,"dd.MM.yyyy",null,null). I just utilize the new property in my xslt report.