Hello
I have been given some data to process daily, it has a date column but its formatted as Text, and has a short month, for example it looks like:
01 Jan
Data in DOMO looks like:
There is another column that has the full month name and the year (as a month summary) so i have trued to split out the Short and Date Summary to make something like 01 January 2024 and convert it to a date format but the ETL is throwing up an error saying it cannot convert it.
Is there another way?
Thanks
Rob