Format date change from US/Europe while exporting to excel using macro

Safa_Guedria — Thu, 27 Apr 2023 09:23:05 GMT

Hello,

We use a macro to export a table in Excel.

the table contains dates, when we open the file with Excel in US version the dates are correct, in the right format DD/MM/YYYY but when we open it in Frensh version, the dates with day < 13 are changed to MM/DD/YYYY (wrong!).

I found in the internet that the month/day inversion of a date is a recurring problem in VBA but I can't find a solution (Défaut de date US / FR dans un macro (excel-pratique.com) ).

I tried to putting Date(field, "DD/MM/YYYY") on script and also on table properties but no success at all.

Could you please help me to solve this issue?

Thank you in advance.

Re: Format date change from US/Europe while exporting to excel using macro

Safa_Guedria — Thu, 27 Apr 2023 09:50:16 GMT

@Frank_S @Gysbert_Wassenaar

could you please help me to solve this issue?

topic Format date change from US/Europe while exporting to excel using macro in Qlik Automate

Format date change from US/Europe while exporting to excel using macro

Re: Format date change from US/Europe while exporting to excel using macro