Problems with Import CSV

0
I'ven trying to use this module market, in mendix to import a list with attributes like: Strings, ENUM, Int & Dates. But when i tried to import with the date formate gives me an error so i want some help to get over this error pls! help. I tried in the entity model use date as string and after that convert to the date format (parseDateTime($fechaString, 'yyyy-MM-dd')) when the microflow create the new entity. But it doesnt Work!.   Note: When i not use the date format, it works perfectly.
asked
2 answers
1

Could be an issue with the pattern that you are mentioning. I see in the excel that the pattern is MM/dd/yyyy, when parsing this with yyyy-MM-dd this will not result in a correct date. The parsing pattern should be the same as the data. Then you can use the formatdatetime functions to get it the way you would like to have the date if needed.

answered
0

Hi Roy Glennon Hudson Ortega,

Just change the date&time attribute type to string and then refresh the import excel template,

now try to import it will work.

answered