How do I successfully import dates using Excel Importer module?

1
One of my entity attributes is a Date and time type and I'm trying to import an Excel spreadsheet with column values such as 04/14/2015 (ie. dd/mm/yyyy). Unfortunately, after the import, this date has been changed to 10/6/1950. Since this is my first attempt at importing data into Mendix can anyone give me some tips as to how I should be formatting my date excel columns? Or should I be importing into a string type attribute and then do some post-processing steps?
asked
1 answers
1

format the data as TEXT. This solved a lot of my imports from different sources (xls, xlsx) from external systems.

answered