string to date&time

Hello - I am struggling to convert a string of MMM-dd-yy HH:mm:ss using the String to Date&Time node. Could someone look at this and let me know how I should proceed?

I have tried splitting, joining and then used the String to Date&Time node, but it still wouldn’t work.

Thanks.

date

Hi @sw1336,
I think the issue here is that your months are written with only capital letters. Your format MMM-dd-yy HH:mm:ss is correct but can only parse ‘Jul’, ‘Aug’, etc. but not ‘JUL’ and ‘AUG’. A simple fix is using the String Manipulation node and its capitalize() function. Afterwards, the conversion to date&time should work.

Best,
Simon

4 Likes

Oh, I didn’t know that!! Many thanks @SimonS

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.