String to date/time question

Snowy · October 11, 2019, 3:13pm

Hi,
Here is a sample of my data set. I have column “Date” that is formatted as a String that I need converted to a date.

On the String Date&Time node I have it configured as follows:

Yet it results in an error:

I have the String Date&Time (Legacy) node configured the same way:

And it results in the node being completed:

Am I missing something as to why the current String to Date & Time node is not completing?

Thanks for your help

ScottF · October 11, 2019, 6:30pm

Try M/d/yyyy instead (single digits for month and day). This should then work in the current node.

Sorry for the trouble.

Snowy · November 4, 2019, 4:34pm

Hi!
I have another String to Date/Time question I can’t seem to figure out.

The dates are formatted such as: Nov 04, 2018

Based on the documentation from: https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html I thought the expression should then be: “M/L dd, yyyy” however I receive an error.

Thanks for your help

ScottF · November 4, 2019, 4:44pm

For this case, use MMM d, yyyy. I just tested, and it should work.