Custom date formats in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to format the date as 'Month Day, Year' in Tableau.

Tableau

FORMAT([Order Date], '[1]')

Drag options to blanks, or click blank then click option'

Ayyyy/MM/dd

BMM-dd-yyyy

Cdd/MM/yyyy

DMMMM dd, yyyy

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'MM' instead of 'MMMM' shows month as number, not name.

Forgetting the comma after the day.

The format string 'MMMM dd, yyyy' displays the full month name, day with two digits, and four-digit year, e.g., 'January 05, 2023'.

2fill in blank

medium

Complete the code to display the date as 'Day-Month-Year' with two-digit day and month.

Tableau

FORMAT([Ship Date], '[1]')

Drag options to blanks, or click blank then click option'

Ayyyy-dd-MM

BMM-dd-yyyy

Cdd-MM-yyyy

Ddd/MM/yyyy

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping day and month positions.

Using slashes instead of dashes.

The format 'dd-MM-yyyy' shows day and month as two digits separated by dashes, e.g., '05-01-2023'.

3fill in blank

hard

Fix the error in the code to format the date as 'Year.Month.Day'.

Tableau

FORMAT([Delivery Date], '[1]')

Drag options to blanks, or click blank then click option'

Ayyyy-mm-dd

Byyyy.MM.dd

Cyy.MM.dd

Dyyyy.MM.DD

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'mm' instead of 'MM' for month shows minutes instead.

Using uppercase 'DD' for day causes errors.

The correct format uses lowercase 'dd' for day and uppercase 'MM' for month. 'yyyy.MM.dd' shows the full year, month, and day separated by dots.

4fill in blank

hard

Fill both blanks to format the date as 'Abbreviated Month Day, Year' and time as 'Hour:Minute AM/PM'.

Tableau

FORMAT([Timestamp], '[1]') + ' ' + FORMAT([Timestamp], '[2]')

Drag options to blanks, or click blank then click option'

AMMM dd, yyyy

BHH:mm

Chh:mm a

DMMMM dd, yyyy

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'HH:mm' with AM/PM causes confusion.

Using full month name instead of abbreviated.

'MMM dd, yyyy' shows abbreviated month name, day, and year, e.g., 'Jan 05, 2023'. 'hh:mm a' shows 12-hour clock with minutes and AM/PM.

5fill in blank

hard

Fill all three blanks to create a custom format showing 'Weekday, Month Day, Year' and 24-hour time 'Hour:Minute:Second'.

Tableau

FORMAT([Event Date], '[1]') + ', ' + FORMAT([Event Date], '[2]') + ' ' + FORMAT([Event Date], '[3]')

Drag options to blanks, or click blank then click option'

Adddd

BMMMM dd, yyyy

CHH:mm:ss

Dddd

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'ddd' instead of 'dddd' for full weekday name.

Using 12-hour time format when 24-hour is requested.

'dddd' shows full weekday name, 'MMMM dd, yyyy' shows full month name, day, and year, and 'HH:mm:ss' shows 24-hour time with seconds.