---
schema_version: "1"
id: 42f0f3a03df2be722642cb49a9f6f1bf155ff85643eb8ce6671b19f4959b4f2f
title: Custom Dates
collection: tableau
version: current
locale: en-us
portal_url: https://docs.salesforce.com/tableau/current/en-us/pro/desktop/dates_custom.md
canonical_url: https://help.tableau.com/current/pro/desktop/en-us/dates_custom.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 574a6c4a6bd6849f1df004a80ad6c55f7ceef936c4b40c5bbd216ee193d11080
description: Create custom dates using DATEPART or DATETRUNC to work at a specific date level.
---
[Skip to main content](#main-content)

# Custom Dates

Custom dates are useful if you always use a date at a specific level, or if you want to create calc that rely on a binned or truncated date.

You can create a custom date in the Data pane or writing a calc with the `DATEPART`or `DATETRUNC` functions.

1. Right-click (control-click on Mac) a date field in the Data pane and select Create > Create Custom Date.
2. From the Detail list, select the level you want.
3. Specify whether you want the custom date to be discrete (Date Parts) or continuous (Date Value).
    
    ![Interface for creating a custom date filter with options for detailing by quarters.](/tableau/current/en-us/pro/desktop/en-us/Img/customdate1.png)
4. Optional: Enter your own name for the field.
5. When you're finished, click OK.

Custom dates created this way appear as new fields in the Data pane.

## Example - format column headers as Month, Day, Year

This example uses the Sample - Superstore data source.

1. Drag \[Order Date\] to Columns.
2. Drag Sales to Rows.
3. Right-click \[Order Date\] on the Columns shelf and choose More > Custom.
4. In the Custom Date dialog box, choose Month / Day /Year from the Detail drop-down list.

The view now has the column headers in the correct format:

![A line chart of sales trends from January 4, 2011 to February 2, 2011.](/tableau/current/en-us/pro/desktop/en-us/Img/month_day_year.png)