How to change the date format mm/dd/yy to mm/dd/yyyy format

[Boopathi (Boopathi Manogar)]

HI All, I am extracting the data in excel which contains a date vale i.es 10/01/18 (mm/dd/yy) format which I need to change into 10/01/2018 (i.es mm/dd/yyyy) format

I tried with cdate(datevalue).tostring(“mm/dd/yyyy”) which is not giving excat value the output I am getting is 10/dd/yyyy format

can you please advise on th

[mz3bel (Mohssine HILAL)]

Hi @Boopathi

Check this below might help

Get a date in formart "dd/mm/yyyy"

@Bruno_Luan_Carvalho It sounds like you said that on the website the dates are in “dd/mm/yyyy” format? I think you need to treat it normally as a string and just write it in that format to Excel. You can change the default date format that your computer sees by going to Control Panel > Region and Language. Changing that setting will see the day and month in the correct spot. However, if you don’t want to change your region and use the basic mm/dd format so you want to convert it then you woul…