How to convert dd/MM/YY to dd/MM/YYYY from Excel

[Soudios (Sou)]

i have an error
process XML DATE V4.zip (55.5 KB)

[prasath17 (Guru)]

@Soudios - So you would like to convert dd/MM/yyyy to dd/MM/yy??

[hariapn (Hari Kumar)]

Hi @Soudios
Please refer

How to get Dates and Times from Excel in the right format with UiPath - Full Tutorial

[Soudios (Sou)]

Yes i forgot to change the format date, it 21/11/13 normally

[prasath17 (Guru)]

@Soudios - Here you go…

Input

Output

Fixex XAML code: process XML DATE V4.zip (56.7 KB)

Hope this helps…

[Soudios (Sou)]

Hi @prasath17

I change the Excel file and it doesn’t work for me.

process XML DATE V5.zip (57.2 KB)

[prasath17 (Guru)]

@Soudios - This is the same issue you faced last time too…please check the code I provided and use the debug mode/debug tools to see what is the error…

[Soudios (Sou)]

@prasath17
Thank you but in the xml file, there is a difference between the format in Excel and xml for DATE_NAISSANCE for example.

Do you know how can i do to have dd/MM/yyyy ?