Hi: I have a table with dates as text as in the following examples: Nov 21, 2021 08:12:31 AM I am trying to convert to datetime with String to Date&Time node providing the following format: ‘MMM dd, yyyy hh:mm[:ss[.sss]] a’ (without the colons) but it does not work. I tried capitalizing, uppercasing, and lowercasing the month and am/pm in all possible combinations, but none of them works. Of course I can do it with a small java script, but my user’s community are not programmers and I need a non-coding solution. Any idea on what’s happening?

string to date MMM dd, yyyy hh:mm[:ss[.sss]] a format not working

ipazin December 1, 2021, 3:59pm 3

this is related to locale change in Java. See here for more:

Br,
Ivan

3 Likes