How to Add Date in Looker Studio

Working with dates is fundamental to almost any report, but getting Looker Studio (formerly Data Studio) to show them exactly how you want can be tricky. Whether you're trying to add a date filter, format dates for a chart, or create custom time-based calculations, mastering dates is essential. This guide will walk you through everything you need to know about adding and manipulating dates in your Looker Studio reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does Proper Date Handling Matter, Anyway?

Before we get into the "how," let's quickly cover the "why." Properly configuring dates is the foundation of powerful, accurate analysis. When your dates are set up correctly, you can:

• Create Time-Series Charts: Visualize trends over time, like daily website traffic or monthly sales, to spot patterns, seasonality, and growth.
• Compare Time Periods: Easily compare performance this quarter to last quarter, or this month to the same month last year, to measure progress and understand performance changes.
• Enable User-Friendly Filtering: Add a date range control to your dashboard, allowing viewers to select the exact time frame they want to analyze without you needing to build dozens of different reports.
• Segment Data Effectively: Break down your data by day of the week, month, or quarter to answer specific questions like, "Which day of the week generates the most Shopify sales?" or "Are Q4 marketing campaigns more effective than Q1's?"

In short, getting your dates right transforms a static report into an interactive and insightful analytical tool.

Checking Your Default Date Dimension

Most of the time, when you connect a data source like Google Analytics, Google Sheets, or BigQuery, Looker Studio does a good job of automatically identifying the primary date column. But it's always a good idea to confirm this before building your charts. An incorrect data type is the most common reason why dates don't behave as expected.

Here’s how to quickly check and fix it:

Step 1: Go to Your Data Source Settings In your Looker Studio report, navigate to the menu and click Resource > Manage added data sources.

Step 2: Edit Your Data Source Find the data source you're working with in the list and click the EDIT link on the right.

Step 3: Find Your Date Field and Check its "Type" You'll see a list of all the fields (dimensions and metrics) in your data source. Find your date field (it might be named "Date," "day," "created_at," etc.). Look across to the ‘Type’ column. It should show a calendar icon and be set to a Date or Date & Time type.

Step 4: Change the Type if Necessary If your date is showing up as a ‘Text’ or ‘Number’ type, Looker Studio won’t be able to use it for date-based functions. Click the drop-down arrow next to the current type, navigate to Date & Time, and choose the correct format, usually Date (YYYYMMDD) or a similar variant.

Once you’ve confirmed your primary date field is correctly typed, you can use it in charts and, most importantly, as the dimension for a Date Range Control.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Adding a Report-Wide Date Range Control

One of the most powerful features in Looker Studio is the ability to add a dynamic date filter that applies to your entire report (or just a specific page). This lets you or your stakeholders analyze any time period on the fly.

Here's how to set it up:

1. From the top menu, click Add a control.
2. Select Date range control from the dropdown list.
3. Click anywhere on your report canvas to place the control. You can drag and resize it like any other element.
4. With the date range control selected, look at the Properties panel on the right. Under the Setup tab, make sure the "Date Range Dimension" is your primary date field (e.g., 'Date').
5. You can also set a Default date range here, such as 'Last 30 days' or 'This month', which is highly recommended for user convenience.

That's it! Now, anyone viewing the report can use this control to filter all the charts on the page by a specific period.

Creating Custom Dates with Calculated Fields

Sometimes, the default date isn't enough. You might want to display the month and year, extract the day of the week, or calculate the time between two events. This is where calculated fields are incredibly useful. You can create new dimensions by applying formulas to your existing date field.

To create a calculated field, go back to your data source editor (Resource > Manage added data sources > Edit) and click ADD A FIELD in the top left.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Useful Date Formulas and Functions

In the calculated field dialogue, you'll give your new field a name and enter a formula. Here are some of the most common and powerful date functions you can use:

1. FORMAT_DATETIME

This is the most versatile function for changing how a date is displayed. You can use it to turn a full date like '2024-10-26' into something more readable like 'October 2024' or 'Saturday'. The formula structure is FORMAT_DATETIME("format_string", date_field).

Example 1: Display Month and Year (e.g., "Oct 2024") Ideal for monthly trend charts where the full date is too crowded.

• Field Name: Month Year
• Formula: FORMAT_DATETIME("%b %Y", Date)

Example 2: Display Day of the Week (e.g., "Saturday") Perfect for analyzing weekly performance patterns.

• Field Name: Day of Week
• Formula: FORMAT_DATETIME("%A", Date)

Tip: Use %A for the full weekday name ("Saturday") and %a for the abbreviation ("Sat").

2. Parsing Dates from Text or Numbers

Occasionally, your date comes into Looker Studio as a text string or number (e.g., '20241026') that it can't automatically recognize. You can use PARSE_DATE to convert it into a true date format that Looker can understand.

Example: Convert a Number to a Date If your date is a number like 20241026:

• Field Name: Corrected Date
• Formula: PARSE_DATE("%Y%m%d", date_as_number)

3. YEAR, MONTH, and WEEKDAY

If you need to extract a specific part of a date as a number for filtering or calculations, these functions are easier than FORMAT_DATETIME.

Example: Get the Month Number (e.g., 10 for October)

• Field Name: Month Number
• Formula: MONTH(Date)

To get the year, you’d simply use YEAR(Date), and for the day of the week (1 for Sunday, 7 for Saturday), you’d use WEEKDAY(Date).

4. DATE_DIFF

This function calculates the duration between two dates. It's fantastic for analyzing things like customer lifecycle, time to conversion, or sales cycle length.

Example: Calculate Days Between Order and Shipping Imagine you have two date fields: order_date and ship_date.

• Field Name: Days to Ship
• Formula: DATE_DIFF(ship_date, order_date)

This will return the difference in days. You can also calculate the difference in weeks, months, or years by modifying the formula slightly, though 'days' is the most common use case.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Common Problems and How to Fix Them

Even with the steps above, you can run into a few common snags. Here’s a quick troubleshooting guide:

Problem: "My date is showing as 'null' or an error in my charts." Solution: This almost always means there's an issue with your calculated field formula or an incorrect data type. Go back to the data source editor. Double-check that your base date field is a proper 'Date' type. Then, review your formula for typos. Make sure the field names inside your formula exactly match the field names in your data source.

Problem: "The dates on my chart are out of order (e.g., April, August, December...)." Solution: This happens when you format your date as a text field that doesn't sort chronologically, like "Day of Week" or "Month Name." Looker Studio sorts text alphabetically by default. The best way to fix this is to create a second calculated field for a numeric version (e.g., WEEKDAY(Date) or MONTH(Date)) and use that field to sort your chart while still using the text version as the display dimension. You can set the sort order in the chart properties panel, separate from the dimension.

Final Thoughts

Managing dates in Looker Studio moves from frustrating to easy once you know where to look. By making sure your date dimensions are correctly typed, using the date range control for interactivity, and flexing creative muscles with calculated fields, you can build truly insightful, user-friendly dashboards that tell a story over time.

For many teams, the setup work within tools like Looker Studio - writing formulas, tweaking data types, and configuring dashboard controls - still creates a bottleneck. At Graphed, we’ve automated this entire process. You can connect sources like Google Analytics or Shopify in a few clicks, and then simply ask for what you want in plain English. Instead of writing a FORMAT_DATETIME formula, you can just ask, "Show me revenue by month for the last year," and we'll instantly generate the chart for you in a live dashboard, no setup required.