Date and Time Fields in Tableau – Complete Detailed Notes

Date and Time Fields are essential in Tableau because they allow users to analyze business data according to days, weeks, months, quarters, years, and specific times. They help organizations understand sales trends, customer activity, order patterns, employee performance, transaction history, and other time-based metrics.

For example, a retail company can use an Order Date field to compare monthly sales, identify seasonal trends, and determine which quarter generated the highest revenue. A Date & Time field can also help analyze when orders were placed or when deliveries were completed.

Course Link: JustAcademy Tableau Training

Demo Link: Register for a Tableau Course Demo

1. Learning Objectives

After completing this topic, you will be able to:

• Understand date and date-time fields in Tableau.
• Identify date data types in the Data pane.
• Understand the difference between Date and Date & Time.
• Recognize discrete and continuous dates.
• Use date hierarchies to explore data at different levels.
• Create date filters and time-based visualizations.
• Use common Tableau date functions in calculated fields.
• Convert text values into recognized dates.
• Identify common date-related problems and troubleshoot them.
• Build practical reports such as monthly sales trends and daily order analysis.

2. What Are Date and Time Fields?

Date and Time fields represent calendar dates, times, or timestamps in a dataset. Tableau recognizes date values and provides specialized features for filtering, formatting, grouping, and calculating with dates.

A date field may contain only a calendar date, while a date-time field contains both the date and the time of day.

Examples

Recognized date fields provide Tableau with more functionality than ordinary text fields that merely look like dates.

3. Date vs. Date & Time

Tableau distinguishes between Date and Date & Time data types. Choosing the correct type helps determine the level of detail available for analysis.

Example: If a company wants to compare total sales for each calendar day, a Date field may be sufficient. If it wants to determine which hour receives the most orders, it should preserve and use the time component from a Date & Time field.

4. How to Identify Date Fields in Tableau

Tableau displays icons beside fields in the Data pane to indicate their data types. Recognized date fields have date-related icons that distinguish them from strings and numeric fields.

Steps

1. Open Tableau Desktop or Tableau Public.
2. Connect to a data source, such as an Excel file, CSV file, or database.
3. Open a worksheet.
4. Locate the Data pane on the left side.
5. Find fields such as Order Date, Ship Date, or Created At.
6. Check the icon beside each field to determine whether Tableau recognizes it as a date or date-time field.
7. If a field containing dates is recognized as a string, inspect its values and correct the data type if appropriate.

Important: A value that looks like a date is not necessarily stored as a date. If the source field is text, Tableau may not provide all date-specific functionality until it is converted correctly.

5. How to Change a Field to Date or Date & Time

If Tableau incorrectly identifies a field, you can change its data type through the Data Source page or Data pane.

Method 1: Change the Data Type on the Data Source Page

1. Connect to the dataset.
2. Open the Data Source page.
3. Locate the date-related column.
4. Click the data type icon beside the field name.
5. Select Date or Date & Time, depending on the field's actual meaning.
6. Inspect the values to confirm that Tableau interprets them correctly.
7. Open a worksheet and test the field in a visualization.

Method 2: Change the Data Type from the Data Pane

1. Open a worksheet.
2. Find the field in the Data pane.
3. Open the field's context menu or click its data type icon.
4. Select the appropriate date-related data type if available.
5. Check the resulting field and any views that use it.

If the field becomes mostly null or displays incorrect dates after conversion, return it to String and investigate the source format before proceeding.

6. Date Parts and Date Values

When using a date field in Tableau, you can analyze the date at different levels, such as Year, Quarter, Month, Week, or Day. Tableau provides date-specific options that make it easier to summarize and explore data.

Common Date Parts

The available levels and display options depend on the date field and the type of date value used in the view.

Example

A company has 100,000 order records with individual dates. Instead of examining every record separately, it can summarize sales by month or quarter to identify larger business trends.

7. Discrete and Continuous Dates

Tableau allows dates to be used as discrete fields or continuous fields. This distinction affects how dates appear in a visualization and how the axis is displayed.

7.1 Discrete Dates

Discrete dates create separate categories or headers for date values. They commonly appear as blue pills in Tableau.

Examples: January, February, March, or individual years such as 2024, 2025, and 2026.

Typical uses:

• Comparing sales by month name.
• Displaying separate columns for each year.
• Creating date-based categories.
• Comparing a selected group of periods.

7.2 Continuous Dates

Continuous dates create an unbroken date axis across a range of values. They commonly appear as green pills in Tableau.

Examples: A timeline from January through December or a daily sales trend across several months.

Typical uses:

• Showing sales trends over time.
• Displaying a continuous timeline.
• Analyzing changes in a metric across a date range.
• Identifying increases, decreases, and seasonal patterns.

Comparison Table

How to Switch Between Discrete and Continuous

1. Drag a date field into Rows or Columns.
2. Click the drop-down arrow on the date pill.
3. Choose an appropriate date level.
4. Select the discrete or continuous option where available.
5. Observe how the visualization changes.

Remember: Discrete and continuous describe how the field is used in the view. They do not mean the underlying date values have changed.

8. Date Hierarchies in Tableau

A date hierarchy allows users to navigate from a broader date level to a more detailed level. Tableau commonly provides a hierarchy for recognized date fields.

Typical Date Hierarchy

Year
 └── Quarter
      └── Month
           └── Day

The exact hierarchy and available drill-down options depend on the date field and Tableau configuration.

How to Use a Date Hierarchy

1. Drag a date field into the worksheet.
2. Use the date hierarchy or choose a date level from the field's menu.
3. Start at Year or Quarter to view summarized information.
4. Use the drill-down controls or add more detailed date levels.
5. Continue to Month or Day to examine more detailed performance.

Example

A sales manager first reviews yearly revenue, then drills down into a quarter, then into a month, and finally into individual days to investigate an unusual sales result.

9. Date Filters in Tableau

Date filters allow users to limit the data shown in a worksheet or dashboard to a particular time period. They are useful for examining recent performance, historical records, and selected reporting periods.

Common Date Filter Options

Steps to Create a Date Filter

1. Drag the date field to the Filters shelf.
2. Select a suitable filter type, such as a range or relative date filter.
3. Set the required dates or date period.
4. Confirm the filter settings.
5. If needed, display the filter so users can change the selected period.

Date filters help dashboards focus on the relevant reporting period. When building a dashboard, verify that the filter affects the intended worksheets.

10. Formatting Date and Time Fields

Formatting changes how a date or time value appears in the visualization. It does not necessarily change the underlying date value.

Examples of Date Formats

How to Format a Date Field

1. Right-click the date field or its axis or header in the worksheet.
2. Select the available formatting option.
3. Choose a suitable date or date-time format.
4. For a custom display, select a custom date format if available.
5. Verify that the displayed date is clear and appropriate for the report.

Important: Formatting a date as Month and Year changes its presentation. It does not necessarily remove the day or time information from the underlying field.

11. Important Tableau Date Functions

Tableau provides date functions that help users extract date parts, create dates, compare periods, and calculate date differences.

Function support and behavior can vary by data source. Validate calculated fields with the connection used in your workbook.

12. Using YEAR(), MONTH(), and DAY()

These functions are useful when you need to extract individual components from a recognized date field.

Example: Extract the Year

YEAR([Order Date])

This returns the year number for each order date.

Example: Extract the Month Number

MONTH([Order Date])

This returns a month number from 1 to 12 for valid dates.

Example: Extract the Day

DAY([Order Date])

This returns the day of the month, typically from 1 to 31.

Practical Use

These functions can help build calculated fields for year-wise reporting, monthly comparisons, and day-level analysis. For example, the year extracted from Order Date can be used to compare annual sales performance.

13. Using DATEPART() and DATENAME()

Both functions extract a specific component from a date, but they return different types of values.

DATEPART()

DATEPART() returns a date component as an integer.

DATEPART('year',[Order Date])

For a date in 2026, this returns the integer 2026.

DATENAME()

DATENAME() returns the requested date component as a string.

DATENAME('month',[Order Date])

For an October date, this returns the month name as text, such as October, subject to the applicable language and date settings.

Comparison

14. Using DATEADD()

DATEADD() adds or subtracts a specified number of date units from a date.

Syntax

DATEADD(date_part, interval, date)

Example: Add Seven Days

DATEADD('day',7,[Order Date])

This returns a date seven days after the original order date.

Example: Subtract One Month

DATEADD('month',-1,[Order Date])

This returns a date one month earlier, using Tableau's date arithmetic rules.

Business Applications

• Calculate expected delivery dates.
• Create reminder dates.
• Analyze dates before or after an event.
• Build reporting windows based on a starting date.

15. Using DATEDIFF()

DATEDIFF() calculates the difference between two dates in a selected date unit. It is useful for measuring delivery time, customer tenure, processing duration, and other time intervals.

Syntax

DATEDIFF(date_part, start_date, end_date)

Example: Delivery Duration

DATEDIFF('day',[Order Date],[Ship Date])

This calculates the difference in day boundaries between the order date and ship date.

Example: Employee Tenure in Years

DATEDIFF('year',[Joining Date],TODAY())

This calculates the number of year boundaries between the joining date and today. It should not automatically be treated as an exact completed-years calculation for every date pair.

Common Date Units

• 'year' – year boundaries
• 'quarter' – quarter boundaries
• 'month' – month boundaries
• 'week' – week boundaries, subject to the configured week-start convention
• 'day' – day boundaries
• 'hour' – hour boundaries
• 'minute' – minute boundaries
• 'second' – second boundaries

Important: The result of DATEDIFF is based on the specified date part, not necessarily a precise elapsed duration in that unit. For example, two dates close together but on opposite sides of a month boundary can produce a difference of one month.

16. Using DATETRUNC()

DATETRUNC() truncates a date to the beginning of a specified date period. It is useful when you want to group dates consistently into weeks, months, quarters, or years.

Syntax

DATETRUNC(date_part, date)

Example: Truncate to Month

DATETRUNC('month',[Order Date])

If the original date is October 14, 2026, the result is the first day of that month, October 1, 2026.

Example: Truncate to Year

DATETRUNC('year',[Order Date])

This returns the beginning of the year containing the original date.

Common Uses

• Group transactions by month.
• Standardize dates for monthly comparisons.
• Compare performance by quarter or year.
• Create a consistent date field for trend analysis.

Truncation changes the calculated date value. It is different from simply formatting a date to hide its day or time component.

17. Converting Text to Date

Some datasets contain dates stored as strings. Before using these values for date analysis, they may need to be converted into recognized date values.

Example Dataset

Using DATE()

DATE([Order Date Text])

DATE() can convert compatible expressions when Tableau recognizes the date format.

Using DATEPARSE()

When the string uses a specific format that Tableau does not automatically recognize, DATEPARSE() may be appropriate where supported by the connection.

DATEPARSE('yyyy-MM-dd',[Order Date Text])

The format string must match the actual date text. For example, a string in day/month/year format requires a different pattern from a string in year-month-day format.

Validation Steps

1. Inspect the original text values.
2. Identify the exact date pattern.
3. Choose DATE() or a supported DATEPARSE() calculation.
4. Inspect the resulting dates and null values.
5. Compare converted results with known source records.

18. Date Literals in Tableau

In Tableau calculations, date literals can be written using the hash symbol around the date value. This helps Tableau interpret the expression as a date rather than ordinary text.

Example

#2026-10-14#

A date literal can be used in comparisons or date calculations.

Example: Filter a Date Range in a Calculation

[Order Date] >= #2026-01-01#
AND [Order Date] < #2027-01-01#

This condition checks whether the order date falls within calendar year 2026. The exclusive end date includes all recognized dates before January 1, 2027, which is especially useful when the source field includes timestamps.

Use date literals carefully and verify that the date format is interpreted as intended.

19. Practical Example: Monthly Sales Analysis

Objective: Create a Tableau visualization that compares sales across months.

Sample Dataset

Note: The values are fictional and intended for practice.

Step 1: Connect to the Dataset

Open Tableau and connect to the Excel or CSV file containing Order Date, Region, and Sales.

Step 2: Verify the Date Field

Confirm that Order Date is recognized as Date or Date & Time. If it is stored as text, convert it after checking the source format.

Step 3: Create a Worksheet

Open a new worksheet and drag Order Date to Columns.

Step 4: Select the Month Level

Use the date pill's menu to select the appropriate month level. Choose a discrete month for separate categories or a continuous month for a time axis, depending on the analysis.

Step 5: Add Sales

Drag Sales to Rows. Tableau will typically aggregate the measure, often using SUM.

Step 6: Choose a Chart

Use a bar chart for comparing monthly totals or a line chart for showing the trend over time.

Step 7: Add Region

Drag Region to Color or Filters to compare regions or focus on a selected area.

Step 8: Interpret the Results

Review the monthly totals, identify changes in sales, and compare the results across regions. Confirm that the chart uses the intended year if the dataset contains multiple years.

20. Practical Example: Calculate Delivery Days

Objective: Calculate the number of days between an order date and a ship date.

Sample Dataset

Step 1: Create a Calculated Field

Choose Analysis → Create Calculated Field.

Step 2: Name the Field

Enter Delivery Days as the field name.

Step 3: Enter the Formula

DATEDIFF('day',[Order Date],[Ship Date])

Step 4: Validate the Results

Place Order ID and Delivery Days in a text table. Check each result against the dates in the source.

Step 5: Analyze Delivery Performance

Use the calculated field to compare delivery intervals and identify orders with longer processing times. If the business requires exact elapsed time or business days only, use a calculation designed for that definition.

21. Common Date and Time Problems

Problem 1: Dates Are Stored as Strings

Cause: The source file may contain dates as text.

Solution: Check the field's data type and convert compatible values using the Data Source page, DATE(), or a supported DATEPARSE() expression.

Problem 2: Dates Display as Null

Cause: The date pattern may be invalid, inconsistent, or incompatible with the chosen conversion.

Solution: Inspect the original values, standardize the source, and verify the parsing pattern.

Problem 3: Day and Month Are Reversed

Cause: The source may use day/month/year while the conversion assumes month/day/year, or vice versa.

Solution: Confirm the source convention and use an appropriate parsing pattern when supported. Validate the result with known dates.

Problem 4: Time Information Disappears

Cause: The field may have been converted to Date rather than Date & Time, or the visualization may display only the date.

Solution: Determine whether the underlying time component is needed. Use Date & Time for timestamp analysis and inspect the formatting when the time is merely hidden.

Problem 5: Dates Are Sorted Incorrectly

Cause: Dates may be stored as strings, or month names may be sorted alphabetically rather than chronologically.

Solution: Use a recognized date field for chronological sorting and verify the selected date level.

Problem 6: Months from Different Years Are Combined

Cause: A month name alone does not uniquely identify a year.

Solution: Include Year in the view or use a full date level that preserves the required year context.

Problem 7: Relative Date Filters Show Unexpected Results

Cause: The filter may use a different reference period, date level, or connection context than expected.

Solution: Review the filter configuration, the underlying date field, and the relevant system or connection date context.

Problem 8: Date Differences Do Not Match Elapsed Time

Cause: DATEDIFF counts boundaries of the selected date part rather than always calculating an exact elapsed duration.

Solution: Confirm the business definition. For elapsed hours or minutes, select an appropriate date part and account for the field's precision and time-zone requirements.

22. Best Practices for Date and Time Fields

1. Use the correct data type: Choose Date for calendar dates and Date & Time for timestamps when the time component matters.
2. Validate source formats: Confirm whether dates use year/month/day, day/month/year, or another convention.
3. Keep original values when needed: Preserve the source field when conversion requires cleaning or troubleshooting.
4. Choose the appropriate date level: Use Year, Quarter, Month, or Day according to the reporting objective.
5. Use continuous dates for trends: A continuous axis is often useful for line charts showing change over time.
6. Use discrete dates for comparisons: Separate date categories can be useful for comparing selected periods.
7. Be careful with month names: Include the year when analyzing data from multiple years.
8. Understand date functions: Choose functions such as DATEDIFF(), DATEADD(), and DATETRUNC() according to the intended calculation.
9. Check null values: Investigate invalid or missing dates before relying on the report.
10. Check time zones: For timestamp data, confirm the source and connection's time-zone context where relevant.
11. Use consistent formatting: Choose readable date and time formats that suit the audience.
12. Validate business logic: Confirm whether the analysis needs calendar days, business days, elapsed hours, or another definition.

23. Practice Exercises

1. Connect a dataset containing Order Date and Sales. Create a monthly sales bar chart.
2. Create a continuous date axis and display a line chart showing sales over time.
3. Use YEAR() to create a calculated field containing the order year.
4. Use MONTH() to extract the month number from Order Date.
5. Use DATENAME() to create a month-name field.
6. Use DATEADD() to calculate a date seven days after an order date.
7. Use DATEDIFF() to calculate the difference between Order Date and Ship Date.
8. Use DATETRUNC() to create a month-level date field.
9. Convert a text date field into a recognized date and check the resulting values.
10. Create a date filter that allows users to select a reporting period.
11. Compare discrete and continuous versions of the same date field in a visualization.
12. Investigate why a month-name chart may be sorting alphabetically rather than chronologically.

Exercise Hints

• Exercise 1: Place Order Date on Columns and SUM(Sales) on Rows, then choose the appropriate month level.
• Exercise 2: Choose the continuous date option from the date pill menu where available.
• Exercise 3: Use YEAR([Order Date]).
• Exercise 4: Use MONTH([Order Date]).
• Exercise 5: Use DATENAME('month',[Order Date]).
• Exercise 6: Use DATEADD('day',7,[Order Date]).
• Exercise 7: Use DATEDIFF('day',[Order Date],[Ship Date]).
• Exercise 8: Use DATETRUNC('month',[Order Date]).
• Exercise 9: Verify the date format and choose DATE() or a supported DATEPARSE() expression.
• Exercises 10–12: Check filter settings, date-pill behavior, year context, and chronological sorting.

24. Interview Questions and Answers

Q1. What are Date and Time fields in Tableau?

Answer: They are fields used to represent calendar dates and timestamps. They enable date-specific filtering, grouping, formatting, and calculations.

Q2. What is the difference between Date and Date & Time?

Answer: Date represents a calendar date, while Date & Time represents a calendar date and time of day.

Q3. What is the difference between discrete and continuous dates?

Answer: Discrete dates create separate headers or categories, while continuous dates create a continuous axis across a range of date values.

Q4. What is a date hierarchy?

Answer: It organizes dates into levels such as Year, Quarter, Month, and Day, allowing users to explore data at different levels of detail.

Q5. What is the purpose of YEAR()?

Answer: YEAR() extracts the year number from a date.

Q6. What is the difference between DATEPART() and DATENAME()?

Answer: DATEPART() returns the specified date component as an integer, while DATENAME() returns it as a string.

Q7. What does DATEADD() do?

Answer: DATEADD() adds or subtracts a specified interval from a date.

Q8. What does DATEDIFF() do?

Answer: DATEDIFF() calculates the difference between two dates in a specified unit, such as days, months, or years.

Q9. What is DATETRUNC() used for?

Answer: DATETRUNC() returns a date truncated to a specified level, such as the beginning of a month or year.

Q10. How can you convert a string to a date?

Answer: Use DATE() for compatible formats or DATEPARSE() where supported when the input follows a specific known pattern.

Q11. What is the difference between date formatting and date conversion?

Answer: Formatting changes how a date appears, while conversion changes how Tableau interprets the underlying value.

Q12. Why might a month-based chart show incorrect ordering?

Answer: Month names may be treated as text and sorted alphabetically. Use an appropriate date field or chronological sort and include the year where needed.

Q13. What is the purpose of TODAY() and NOW()?

Answer: TODAY() returns the current date, while NOW() returns the current date and time in the applicable system or connection context.

Q14. Why should date calculations be validated?

Answer: Date formats, week-start settings, invalid values, timestamps, and time-zone differences can affect results. Validation ensures the calculation matches the reporting requirement.

25. Quick Revision Notes

• Date fields represent calendar dates; Date & Time fields represent dates and timestamps.
• Recognized date fields provide date-specific filters, formatting, and hierarchy options.
• Discrete dates create separate categories; continuous dates create a continuous axis.
• Date hierarchies commonly allow exploration from Year to Quarter, Month, and Day.
• Use YEAR(), MONTH(), and DAY() to extract date components.
• Use DATEPART() for integer date parts and DATENAME() for text date parts.
• Use DATEADD() to move a date forward or backward by a selected interval.
• Use DATEDIFF() to calculate differences in specified date units.
• Use DATETRUNC() to standardize dates to a period such as a month or year.
• Use DATE() or a supported DATEPARSE() calculation to convert compatible text values into dates.
• Formatting changes display; conversion changes the interpreted data type.
• Always validate date formats, filters, sorting, time components, and calculated results.

26. Final Checklist

• ☐ I can identify Date and Date & Time fields in Tableau.
• ☐ I understand how to change a field's date data type.
• ☐ I can explain discrete and continuous dates.
• ☐ I can use date hierarchies to explore data.
• ☐ I can create date filters and time-based charts.
• ☐ I understand YEAR(), MONTH(), DAY(), DATEPART(), and DATENAME().
• ☐ I can use DATEADD(), DATEDIFF(), and DATETRUNC().
• ☐ I can convert compatible text dates into recognized date values.
• ☐ I can troubleshoot null dates, incorrect formats, and sorting issues.
• ☐ I can create a monthly sales report and calculate delivery intervals.

27. Official Learning Resources

• Tableau Help: Date Functions
• Tableau Help: Convert a Field to a Date Field
• Tableau Help: Type Conversion

28. Conclusion

Date and Time Fields are fundamental to time-based analysis in Tableau. They allow users to analyze trends, compare reporting periods, calculate date differences, filter data by time, and create interactive visualizations. By understanding date types, discrete and continuous dates, date hierarchies, formatting, and date functions, you can build more accurate and useful business reports.

For further learning, explore JustAcademy Tableau Training and Register for a Tableau Course Demo.