Question

convert string date into date and time format

0

Hi I have an Excel file with a date column containing various date formats (e.g., "end dec," "12/03/2024," "fri 12/24," etc.) that I want to convert to a single format ("dd-MM-yyyy") in Mendix. I've created the following microflow for this purpose.

asked 2024-11-14

Varun Sharma

4 answers

Martin Koelewijn · Answer 1 · 2024-11-14

You have a string variable and if you change it, it's still a string. The parseDateTime function returns a datetime, so you can't change a string variable into that. Create a new datetime variable using the parseDateTime function and put that in a datetime attribute of $IteratorARU. Also double check if you want parseDateTime or parseDateTimeUTC (non-localized).

Also, commit and refresh the list you looped over after the loop instead of committing each object separately in the loop.

Adriaan Bout · Answer 2 · 2024-11-14

You can just create a DateTime variable where you do the parseDateTime of the IteratorARU attribute.

Currently youre creating a String variable which you want to change into a DateTime variable, which is not possible.

Mohammad Saqib · Answer 3 · 2024-11-14

Hi Varun,

Just change the variable type string to dateTime.

Satya Reddy · Answer 4 · 2024-11-15

Hi Varun,

Try as below mentioned hope this helps,