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

HI All, I am extracting the data in excel which contains a date vale 10/01/18 (mm/dd/yy) format which I need to change into 10/01/2018 ( 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

Hi @Boopathi

Check this below might help :point_down: