Posted: 11 Jan 2018 14:13 EST 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.
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.
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.