Problems with date fields

 

I have a CSV file with some fields in date format. When I upload it to looker studio, the field transforms it into a date field. So far everything is correct, the problem is that the sequence of dates does not correspond. The dates from day 1 to 12 are represented with the following format 06/10/2024, where the day becomes the month and the month becomes the day. Starting on the 13th, it represents them with this other format 13/06/2024. The entire column is in the initial format. Please, could someone know how to make the date in the same format? I have tried changing the dates by numerical data and it won’t let me transform it into a date because the DATE_FROM_UNIX_DATE() function does not use a number but rather an interger. Thank you in advance for your help.

Hi Baffitness,

Looker Studio is unfortunately not meant for data wrangling and cleaning. I would recommend, since its in csv, to go in and fix the data using Excel or Google Sheets and after fixing the dates, using that file in Looker Studio, either by exporting to csv or connecting a Google Sheet.

Hope this helps,

Dylan