I have an Excel file with ‘Publish date’ in one column and trying to upload it via Excel import. The related entity in domain model has an attribute for date/time. But when uploading the Excel file, the data for ‘Published date’ is missing. I changed the attribute type to string and it did get the data, but then I can not use it (publish date) as part of an XPath. Now wondering does it have anything to do with the data in excel? do I need to use a different format for date in Excel?
I always make it a string and do the conversion in Mendix. Use the parsedatetime(UTC) function to transform the string to a Mendix date time value.
Add a parse microflow in Excel importer and convert the string(which is date in Excel) to datetime using parsedatetimeUTC function in a variable and return the variable