Hello I am trying to import a date field from an Excel spreadsheet into a string variable in my Mendix app. It does pull the data across, however it flips the Month and day around and changes to dates from a UK format to a US format i.e. 01/10/20 in excel will be 10/1/20 in the Mendix app. All the settings are changed for dates to be UK dates.
asked
Matthew Tranter
1 answers
0
You need to set inside the Excel sheet the cells from date type to a string type. Then you can import them as strings and create a microflow again to transform it into a date.