Date format issue when importing

[Kuroshi]

Hi, I'm trying to import an excel spreadsheet but it says that some dates are not compatible but upon checking the file all of the records are on the same format. Their format is dd/mm/yyyy. Do you know why I encounter this issue?

[Barbie]

Hello, based on the error that you have mentioned it seems that the issue is related to the format of your date values. Our table recognizes the mm/dd/yyyy format. If you're records are on different format, you might encounter this issue. What I can suggest if you really want to use this format, change the DataType from Date/Time to Text instead. Otherwise, change the format of it from dd/mm/yyyy to mm/dd/yyyy. 

I hope this helps.

- Barbie

[Barbie]

Hi @Batchini,

In addition, if you want to convert the imported date with the format of mm/dd/yyyy to dd/mm/yyyy you can use this formula:

CONVERT(DATETIME, [@field:], 103)

- Barbie

[ParkLoey]

Hello there! In any cases you'll need reference to change the format of a date differently again, you can change the 103 in this calculation: 

CONVERT(DATETIME, [@field:], 103)

-  LOEY