Assign a date value in dd/mm/yyyy but excel change to mm/dd/yyyy

CoolRobot · May 3, 2021, 7:34am

Hi i have use a assign in
DateTime.Now.AddDays(-2).ToString(“dd/MM/yyyy”)

but when i write value to it
it become MM/dd/yyyy as a short day
how can i fix it

Pankaj.Patil · May 3, 2021, 7:43am

You can change format in excel before you write it.

you can choose your location and date.

Cheers,
Pankaj

ppr · May 3, 2021, 7:55am

have a look on this activity:
grafik

Topic		Replies	Views
Dates automatically change from dd/MM/yyyy to MM/dd/yyyy in excel Help studio	5	3157	July 14, 2019
Date formatting problem Help studio	3	815	January 16, 2021
Excel: Data goes from dd/MM/yyyy to MM/dd/yyyy Studio datatable , excel , studio , question , activities_panel	9	7425	March 7, 2022
Date Format "dd/MM/yyyy" Goes Wrong While Writing in Excel Help excel , activities , question , data_manipulation	17	17341	December 9, 2022
Date Format from Excel Converter Activities excel , activities , question	8	431	July 13, 2023