Dates in columns in Data Studio
My client wants to see start and end dates for the digital items in my report. I have them in my Google Sheet formatted as mm/dd/yyyy, but when imported into a Data Studio Table they show as a 5 digit number. How can get them to show as dates in mm/dd/yyyy format.?
Re: Dates in columns in Data Studio
Well, first, this is weird that date are displayed like this when they are in the right format (even if the best way for a spreadsheet would be to have date in YYYYMMDD)
In Data Studio, go to your data source, then EDIT, on the field Start and End, change the format.
If it's not working, you will have to change first the date format in your spreadsheet and to connect again with Data Studio