Solved: Import CSV data field format DD/MM/AAAA - Page 2

Adolfo_Enrique_ · 01-21-2021 09:38 AM

Hello everyone! First of all, thank you very much for your help. Honestly, whenever I have asked a question they have answered me very generously.

I find myself in this situation, when trying to import a CSV that contains a date field (DD / MM / YYYY) it shows me the following message.

However if I modify the CSV and change the format of the date field to MM / DD / YYYY. It allows me to import it without problem.

My problem is that users will import files with date fields in the format DD / MM / YYYY.

Can anyone guide me with this problem?
It is possible to import data from a CSV in which the date data (s) are in DD / MM / YYYY format.

I await your help.

Thank you!

Steve

Try this:

DATE(
  CONCATENATE(
    INDEX(SPLIT([FECHA_A_REALIZAR], "/"), 2),
    "/",
    INDEX(SPLIT([FECHA_A_REALIZAR], "/"), 1),
    "/",
    INDEX(SPLIT([FECHA_A_REALIZAR], "/"), 3)
  )
)

View solution in original post