This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Date format error with USA AWS based MySql Server

Posted on 06-27-2024 06:08 AM
Shah_Ishan
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi, I am trying to build some reports for myself on Looker Studio from our System Software which is hosted on AWS.

When i am trying to make a report of the daily Sales data the dates are wrong. For example, if I want the data of 04/06/2024 ( 4th June 2024)  it shows me the data of 06/04/2024 (6th April 2024), I have tried different date format changes but have not been able to resolve the same. One thing I have noticed is that after 12th date of any month the data the is shown is correct where I was checking a data from 17/05/2024 it correctly corresponded to our software data from the same date.

Please help me find a solution for the same.

0 2 158
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
sam8
Staff
Reply posted on --/--/---- --:-- AM

If you edit the date field, you can change the format to "Custom date format". Does that help?

 

Screenshot 2024-07-01 at 10.42.49 AM.pngScreenshot 2024-07-01 at 10.42.41 AM.png

0 Likes

Posted on --/--/---- --:-- AM
Shah_Ishan
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

No, I have already tried to use this but this create more issues in the report.

0 Likes