Custom date formats in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a custom date format in Tableau?

A custom date format in Tableau is a way to display dates in a specific style by using format codes, instead of the default date display.

beginner

Which symbol represents the full year in Tableau custom date formats?

The symbol yyyy represents the full four-digit year, like 2024.

beginner

How do you show the month as a short name (e.g., Jan, Feb) in Tableau custom date formats?

Use MMM to show the month as a short name like Jan, Feb, Mar.

beginner

What does the format code dd represent in Tableau date formatting?

dd shows the day of the month as two digits, for example 01, 15, or 31.

intermediate

How can you display a date as 'Monday, January 1, 2024' using custom date formats in Tableau?

Use the format dddd, MMMM d, yyyy where dddd is the full weekday name, MMMM is the full month name, d is the day without leading zero, and yyyy is the full year.

Which format code shows the full month name in Tableau?

A MMMM

B MM

C MMM

D M

MMMM shows the full month name like January, while MMM shows the short name like Jan.

What does yy display in Tableau date formatting?

A Two-digit year like 24

B Full year like 2024

C Month number

D Day of the week

yy shows the last two digits of the year, for example 24 for 2024.

How would you format a date to show '03/15/24' in Tableau?

A MMMM d, yyyy

B M/d/yyyy

C MM/dd/yy

D dd/MM/yyyy

MM/dd/yy shows two-digit month, day, and two-digit year, matching '03/15/24'.

Which format code shows the day of the week as a short name (e.g., Mon)?

A d

B dddd

C dd

D ddd

ddd shows the short weekday name like Mon, Tue, Wed.

If you want to show the day of the month without a leading zero, which code do you use?

A dd

B d

C DDD

D dddd

d shows the day number without a leading zero, for example 1, 2, 15.

Explain how to create a custom date format in Tableau to show the full weekday name, full month name, day without leading zero, and four-digit year.

Think about combining format codes like dddd, MMMM, d, and yyyy.

Describe the difference between 'MMM' and 'MMMM' in Tableau custom date formats.

One is short form, the other is full name.