String to date/time question

#1

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.
image

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:
image

And it results in the node being completed:
image

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

Thanks for your help

0 Likes

#2

Hi @Snowy -

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

Sorry for the trouble.

5 Likes