Get Free Trial

Date formatting issue in Export to excel

Answered
Subramanian asked on September 23, 2021

Hello Team,
As I have set the date format in the mapping object as YYYY-MM-DD but when we exporting to excel it changes to MM.DD.YYYY format. I would need to download the same type that we set in the mapping object. Could you please assist me with this?

1 answer

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster September 23, 2021

Hi Subramanian,
 
Thank you for posting your question.
 
This behavior is expected: when exporting to Excel, Flexmonster defaults the resulting date format to the one used by your operating system.
 
Please let us know if there is anything else we can help you with.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer