I am trying to convert a string into a date time however it keeps giving me the wrong date. The day and year are correct but the month is set to january. This is my code: parseDateTime($Selection/WarrentyEndDate, 'mm/dd/yyyy') The value i give it is 02/17/2009 and It sets the date to 01/17/2009, which is obviously wrong! I have tried changing the month but it still get the same result. Am i doing something wrong? I can't see anything wrong. Any help be good. Also I am using Mendix 2.4.6 if there is any confusion.
Try using 'MM' instead of 'mm' as 'mm' is the notation for minutes (ie. 12:08 = 'hh:mm'), not month.