Forum Discussion
Formatting date with inconsistent input data in same column
Hi all, I'm having trouble formatting a column of date data which has two date formats from the raw data. The input data has a mixture of d/m/yyyy and dd/mm/yyyy For example there is 2/8/2...
Solution
I ended up using the split column function in query editor, split by delimeter "/". The saving grace is that the data is at least always in day/month/year format. So then I have three columns and merge these in a calculator column using the date function.
It works, if somewhat clunky. Feel free to let me know of any better ideas.
Cheers
Josh