Extract date value from excel in same format

I want to extract the value and keep it with its same format

I want to extract a date from an excel file, this is its format
“dd / MM / yyyy”

when I extract this value from excel, it gives me these results
“845712” or “987452”, etc

I tried, variables of type datetime, but I get an error

I have attached the xls file, and the column is FecNacimiento
Trama de Prueba 18-11-2020.xls (38.5 KB)

@borismh

Check below for your reference too
Tutorial : Convert Number to Date Format - #2 by system

Hope this helps you

Thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.