String to Date Error

Hi,

I used File Reader to load a CSV file and it loads the Date column as a string. I thought I’d use the string to Date&Time node to convert the string to a date but kept running into this error. Any help would be appreciated.

The date format in the csv file is dd/mm/yyyy.

Execute failed: Failed to parse date in row 'Row0: Text ‘6/11/2019’ could not be parsed at index 0

Thanks in advance!

1 Like

hi @sljw,

try this date format:
d/M/yyyy

Greetz, Tommy

3 Likes

It worked! Thank you!

2 Likes

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