Convert string to datetime

I want to convert a column from string to datetime but in my column some rows got this “'24/08/2023”, i can’t convert it.

Error message
ERROR String to Date&Time 5:181 Execute failed: Failed to parse date in row ‘Row0’: Text ‘24/08/2023’ could not be parsed at index 0

@etoughet you could try and split the data by the (maybe) length of the string and the use different conversion settings:

1 Like

Hi @etoughet , what format are the other rows? The mask for 24/08/2023 which would also work with single digit day and month would be d/M/yyyy. What format mask are you using?

If you have 2 very different data formats, then depending on the specific formats of the data, you could also look at this:

or possibly even this:

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