What is Date Value in Tableau?
Working with dates in Tableau is one of the most fundamental skills you'll need, but it can also be a source of confusion. When you drag a date field into your view, it can look and behave in ways you don't expect, sometimes showing years, sometimes months, and sometimes a long continuous timeline. This article will demystify how Tableau handles date values so you can confidently control your visualizations and analyze trends over time.
What is a Date Value in Tableau?
In Tableau, a date value is more than just a piece of text, it's a specific data type that Tableau recognizes and knows how to use for time-based analysis. You'll see Tableau assign a small calendar icon next to date fields and a calendar-with-a-clock icon for datetime fields in your Data pane. This special recognition allows you to easily drill down, roll up, and analyze your data across different time granularities.
To truly master dates, however, you need to understand the two most important concepts for how they behave in a view: being "Discrete" (blue pills) or "Continuous" (green pills).
1. Discrete Dates (Blue Pills)
When you use a date as a discrete value, you're treating each part of that date as a distinct, separate category. Think of them as labels or headers.
- What it Looks Like: The pill on your shelf (Rows or Columns) will be blue. In your chart, this creates distinct labels or columns for each date part, like "2022," "2023," and "2024."
- What it Does: It breaks a date into its individual components. If you select discrete "Year," you get a header for each year. If you select discrete "Quarter," you get headers for Q1, Q2, Q3, and Q4, but it groups all the Q1 data together regardless of the year.
- When to Use It: Discrete dates are perfect for comparing distinct time periods. For example, you might want to compare sales for every Q1 over the last five years to see if there's a seasonal pattern. Here, "Q1" is the category you care about.
Imagine your data covers 2022 and 2023. Dragging your Order Date field out and setting it to discrete MONTH will produce 12 labels on your axis ("January," "February," etc.), with the data from January 2022 and January 2023 summed up together under the "January" label.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
2. Continuous Dates (Green Pills)
When you use a date as a continuous value, you're treating it as part of an unbroken timeline. Think of it as a number line where dates flow from one to the next.
- What it Looks Like: The pill on your shelf will be green. In your chart, this creates a single, unbroken axis that represents the flow of time.
- What it Does: It respects the full chronological context of the date. If you select continuous "MONTH," Tableau doesn't just show "January" - it shows "January 2022," "February 2022," etc., all plotted along a unified axis.
- When to Use It: Continuous dates are ideal for seeing trends and creating forecasts. If you want to see how your revenue has grown month-over-month for the past two years, you need a continuous date axis to show that progression. Line charts are almost always built with continuous dates.
Using the same data, dragging your Order Date field out and setting it to continuous MONTH will produce 24 marks on a single axis (Jan 2022, Feb 2022... Dec 2023), letting you see the ebbs and flows over that entire period.
Date Parts vs. Date Truncations: Deepening the Concept
The blue pill/green pill concept is directly tied to an equally important distinction: whether you are looking at a Date Part or a Date Value/Truncation. When you right-click and drag a date field onto a shelf in Tableau, you'll see a menu with an upper and a lower section - this is the choice you're making.
What are Date Parts? (The Blue Section)
The top section of the menu gives you options like YEAR(Order Date), QUARTER(Order Date), and MONTH(Order Date). These selections correspond to discrete Date Parts.
- Each option here returns a single piece, or "part," of the overall date.
- For example,
MONTH(Order Date)looks at January 15, 2023 and only sees “January.” It ignores the day and the year. - This is why it's used for categorical comparisons, treating "January" as a single bucket for data from any year.
What are Date Values? (The Green Section)
The bottom section gives you options like Year, Quarter, and Month, shown with formatting examples like "May 2015". These are continuous Date Values (also called Date Truncations).
- Each option here keeps the full date but truncates it to a specific level of detail.
- For example, selecting
Month (May 2015)takes the date January 15, 2023 and truncates it to the first moment of its month, effectively treating it as January 1, 2023 for plotting on an axis. - This is why it's used for time series analysis - it positions every data point correctly along the timeline. It sees "January 2023" and "January 2024" as two completely different, chronologically-ordered points.
Common Tableau Date Functions You’ll Actually Use
Beyond dragging and dropping pills, you can create powerful manipulations and calculated fields using Tableau’s date functions. You can open the calculation editor by right-clicking in the Data pane and selecting "Create Calculated Field." Here are a few must-know functions.
TODAY() and NOW()
TODAY(): Returns the current date (e.g., '2024-07-26').NOW(): Returns the current date and time (e.g., '2024-07-26 10:30:00 AM').
Use Case: Create a filter to dynamically show sales for the "Current Month to Date." You could write a calculation like:
[Order Date] <= TODAY() AND DATETRUNC('month', [Order Date]) = DATETRUNC('month', TODAY())
DATEDIFF('date_part', start_date, end_date)
The DATEDIFF function calculates the time difference between two dates. You specify the unit of time you want ('day', 'week', 'month', 'year'), a start date, and an end date.
Use Case: Calculate the average time it takes for a customer to make their first purchase after joining your mailing list. Let's say you have a [Signup Date] and a [First Purchase Date].
DATEDIFF('day', [Signup Date], [First Purchase Date])
You can then drag this new calculated field into your view and change its aggregation to Average to find out your average customer conversion time.
DATEADD('date_part', interval, date)
DATEADD allows you to add a specified amount of time to a date. The 'interval' is a number (it can be negative to subtract time).
Use Case: Determine renewal dates for annual subscriptions. If you have the original [Subscription Start Date], you can find the first renewal date with:
DATEADD('year', 1, [Subscription Start Date])
DATEPARSE('format', date_string)
Sometimes, your data source gives you dates that are formatted as plain text strings (identified by 'Abc' in Tableau). DATEPARSE is your best friend for converting these strings into true date values that Tableau can use.
Use Case: Your data has a text field called [Sale Date String] that looks like "15/01/2023". Tableau can't work with this as is. You need to tell it how to read the format.
DATEPARSE('dd/MM/yyyy', [Sale Date String])
Once you create a calculation with this formula, Tableau will generate a new field with a proper date data type.
Quick Tips for Working with Dates
1. Setting a Custom Fiscal Year
If your company's fiscal year doesn't start in January, you can change this setting easily. In the Data pane, right-click your data source, go to Date Properties, and set the Fiscal year start to the appropriate month. All your fiscal date-part calculations (Fiscal Quarter, Fiscal Year) will now adjust accordingly.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
2. Creating Relative Date Filters
Dragging a date field to the Filters shelf gives you the option of a "Relative Date" filter. This is an incredibly powerful, no-code way to build rolling time windows into your dashboard. You can easily set it to show "Previous 3 Months," "This Quarter," "Year to Date," and more. It updates automatically every time the workbook is opened.
3. Use the 'Create Custom Date' Feature
Sometimes you need a specific date format that's not in the default menu, like "Month / Year." Right-click your date field in the Data pane, select Create > Custom Date. A dialog box will appear allowing you to create a pre-defined discrete or continuous date at whatever level you need. This saves you from having to select it manually every time.
Final Thoughts
Understanding the dual nature of dates in Tableau - as discrete categories or continuous timelines - is the key to unlocking its full analytical potential. By learning to toggle between blue and green pills, using date parts for comparison and date values for trends, and arming yourself with a few key functions like DATEDIFF and DATEPARSE, you'll be able to build clearer, more insightful time-based visuals.
Of course, this is often where the real headache begins: connecting and cleaning date data from multiple platforms, all formatted differently, before you can even begin your analysis in Tableau. If you find yourself in the all-too-common cycle of downloading CSVs and wrestling with date formats just to create a weekly report, we’ve built something that might help. With Graphed you simply connect your data sources – like Google Analytics, Shopify, or your CRM – and describe the report you need in plain English. We instantly generate real-time, interactive dashboards without you ever needing to write a DATEPARSE function again.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.