Data Studio Date Format Explained

Do you design presentations for your business or team projects? If so, you should check out Google Data Studio to make custom graphs and charts that stand out.

The key to effective visualizations is consistency and uniformity. Choosing the right format for your visualization may be subjective, but that choice needs to be reflected in all of your spreadsheets and charts.

Google Data Studio date format makes it so that you can set up the format you want and apply it to your entire graph or chart. It also allows you to hone in on data fields based on certain time frames and date formats, such as years, quarters, weeks, etc.

Keep reading to learn how to properly use the Google Data Studio date format.

Data Studio Date Format

Setting the Google Data Studio Date Format

Data Studio allows you to compare and visualize data using many different methods. This tool allow you to compare sets of data by groups based on the date and time. Formatted data tables can all be formatted the same way.

You want your date to be formatted correctly to make sense. For better data visualizations, here is some important information you should know.

Date and Time Types

Data Studio supports a variety of different types for formatting the date and time. You can see a detailed table with the available formats below.

Date & Time TypeExample
Year2022
Year QuarterQ3 2022
QuarterQ3
Year MonthAug 2022
MonthAugust
ISO Year WeekAug 29, 2022 to Sep 4, 2022 (Week 36)
ISO WeekWeek 36
DateAug 31, 2022
Month DayAug 31
Day of WeekWednesday
Day of Month31
Date & TimeAug 31, 2022, 3:15:39 AM
Date HourAug 31, 2022, 3 AM
Hour3 AM
Date Hour MinuteAug 31, 2022, 3:15 AM
Minute15

These date and time types allow you to be general when comparing times across a wide range. Or you can zoom in on the most specific aspects of the hour or to the minute. 

Data Studio also has several ways that you can display the date or compare data sets by the specific date. You can see some more examples for formatting the date below:

  • 2022
  • Q3 2022
  • Aug 2022

This Data Studio date format allows you to narrow in even closer to a very specific type of date or categorize your data sets by these date types. You can see these examples below:

  • Quarter- Q3
  • Month- August 
  • ISO Week- Week 36
  • Month Day- Aug 31
  • Day of Week- Wednesday
  • Day of Month- 31

Data Studio offers two ways for changing the date and time type in the data field. You can change the date type by finding those options in the “Data Sources” tab. Also, you can make those changes in the tabs for the specific component.

Date and Time Data Types

How to Format Dates in Compatibility Mode

How do you format dates from data sources before a specific date? In Data Studio, dimensions that measure date and time before the date of September 15, 2020 automatically defer to the Date & Time (Compatibility Mode) data type. 

The two options for editing types in compatibility mode are Granularity and Type. You can adjust data groups based on granularity within the date menu.

To adjust compatibility by type, you can update the date & time format so that all data sets match the format. This way you don’t have some data using the compatibility mode (old formatting), mixed in with data using different updated data types.

Once you’ve signed into Data Studio, the following steps to upgrade your data field go as follows:

  • Edit your data source
  • Find the compatibility mode date field to convert
  • On the Right, click Type
  • Then select Date or Date & Time
  • Select the type you want
  • A dialog box will appear to click Upgrade

You can also upgrade the Data Studio date formats by adjusting different fields manually. You can type in the functions like DATETIME_ADD, DATETIME_DIFF, and EXTRACT, along with many other options

Free GA4 Audit - Data Bloo V1

How to Display the Current Date Using Calculated Fields

To do this, you want to create an entirely new field to calculate the current date. Start by selecting “Add a Field,” where you then manually type in CURRENT_DATE (). 

Then you want to specify which time zone to use, otherwise, the system defaults to the UTC time zone. You can do this in the following two ways:

  • Typing in the Time Zone Name CURRENT_DATE (“America/Los Angeles, CA”)
  • Using the Zone Offset Method CURRENT_DATE (“+4”)

The zone offset method serves as the option with the highest usability. Report editors find it easier to understand and read more quickly because it’s written in a more direct format.

How to Format Date for Data Studio in Google Sheets

The data formatting in Google Data Studio doesn’t automatically transfer over to Google sheets. Mainly because Google Sheets defaults to the formatting used across the globe. The US format for a date is MM/DD/YYYY, whereas the format outside the US is DD/MM/YYYY. 

These steps allow you to format all the dates on a spreadsheet to be compatible with Google Data Studio.

First, highlight and select all the boxes with the data sets using the American date format. You then click through the following Format menu options:

  • Format Menu >> Number >> More Formats >> Custom Date and Time

You then select which year-month-day format you wish to use, and then click “Apply.” Now Google Data Studio will be able to read the data in your data sources and charts.

Defaulting to the format of YYYY-MM-DD functions as the best standard practice for dates written in Google Data studio. Formatting the year first allows the data sets to group more easily.

Improve Readability for Visualizations with Date and Formats

Data analysis runs smoothly when you use the right tools to organize and present your data sets cleanly and in a logical way that the eye can follow. The person reading the report should be able to quickly discern spreadsheets and charts because everything follows a pattern.

Google Data Studio date formats make all the data sets in the date and time category align together in one format. This also helps perform functions and makes sure the formulas run properly. The best and most efficient visualizations work as automated functions that are easy to edit and add to.

Visit Data Bloo’s site to see how our tools help you with setting up data visualizations.

GET your GA4 audit For Free

FREE Google Analyitcs 4 Audit

An automated Google Analytics 4 audit of your account with over 25 different check points that gives you clear picture of the quality and the accuracy of your data.