Date column has different formats

[Sammy22]

Hi,

I have a column which has dates in the format dd/mm/yyy however there are some dates (less than10th of each month) which are d/mm/yyyy. When i use the string to date format the latter dates become null. How can i resolve this?

[Emil_Kos]

Hi @Sammy22,

I would propose adding 0 if the length of the column is equal to 9 - instead of expected 10.

[Sammy22]

Just noticed another problem, the month can also only have one number in it, so for example 12th of March 2020 would be 12/3/2020. How do i manage this alongside the day issue?

[Emil_Kos · Accepted solution]

Hi @Sammy22,

I basicly added text to columns to split the data into day month and year column. I have added 0 if needed and I have added the data together.