Convert String field format DD-MM-YYYY to type Date and Time

0
I'm new to the Mendix platform so excuse me for asking something that probably has been asked before (and I can't find in the Forum).  The problem i have to solve is converting a String field, 10 characters, containing a date in DD-MM-YYYY format to a normal Date and time type in the database. Many thanks in advance, Max
asked
3 answers
0

Hi Max, please look at https://docs.mendix.com/refguide7/parse-and-format-date-function-calls

 

parseDateTime('21-05-2015', 'dd-MM-yyyy')

 

answered
0

Hi Max, 

You can use the parseDateTime function to convert the string to a datetime, you can use this in a change action in a microflow. For example 

parseDateTime(22-03-2017, 'DD-MM-YYYY')
answered
0

Hi Max, you can also create a small generic microflow with a string variable as input, and a DateTime variable as output. In the microflow you create the DateTime variable with the parseDateTime function with the input string variable.

answered