I have a source file with a date column Document date (dd/mm/yyyy).
I have just uploaded it as a csv and it contains only dates from January 1-31. However when I put Document date field in a table it seems the looker studio is taking the dates 02/01/2023 to 12/01/2023 and flipping the format to (mm/dd/yyyy). See photo below:
Any idea why this could be happening? I've already checked my csv file and have confirmed the dates are only from 01/01/2023 to 31/01/2023
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |