Date calculations (DATEDIFF, DATEADD) in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate days difference between two dates

Given two dates, Order Date as 2024-01-10 and Ship Date as 2024-01-15, what is the result of the following Tableau calculation?

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

A 5

B 6

C 4

D Error: Invalid function usage

💡 Hint

DATEDIFF counts the number of day boundaries crossed from the first date to the second.

The difference between 2024-01-10 and 2024-01-15 is 5 days because it counts the days between the two dates, excluding the start date.

❓ dax_lod_result

intermediate

Add months to a date using DATEADD

What is the result of this Tableau calculation if Order Date is 2024-03-31?

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

A Error: Invalid date

B 2024-04-31

C 2024-05-01

D 2024-04-30

💡 Hint

Adding one month to March 31 adjusts to the last valid day of April.

Since April has only 30 days, adding one month to March 31 results in April 30.

❓ visualization

advanced

Best visualization for monthly sales growth

You want to show the month-over-month sales growth percentage for the last 12 months. Which visualization type is best to clearly show this trend?

A Bar chart with total sales per month

B Pie chart showing sales distribution by month

C Line chart with months on the x-axis and growth % on the y-axis

D Scatter plot with sales vs. months

💡 Hint

Trends over time are best shown with continuous lines.

A line chart clearly shows how sales growth changes month to month, making trends easy to spot.

❓ dax_lod_result

advanced

Calculate quarter difference between two dates

You have Start Date as 2023-11-15 and End Date as 2024-05-10. Using Tableau's DATEDIFF function, what is the quarter difference?

DATEDIFF('quarter', [Start Date], [End Date])

A 2

B 3

C 1

D 4

💡 Hint

Count how many quarter boundaries are crossed from start to end date.

From Q4 2023 (2023-11-15) to Q2 2024 (2024-05-10) crosses 2 quarter boundaries: January 1, 2024 (start of Q1) and April 1, 2024 (start of Q2).

🔧 Formula Fix

expert

Identify error in date calculation formula

Which option will cause an error when calculating the difference in days between two dates in Tableau?

DATEDIFF('day', [Date1], [Date2])

Assume Date1 and Date2 are fields in the data.

A [Date1] and [Date2] are both valid date fields with no nulls

B [Date1] is a string field with date text, [Date2] is a date field

C [Date1] and [Date2] are both date fields but some values are null

D [Date1] is a date field, [Date2] is a datetime field

💡 Hint

DATEDIFF requires both inputs to be date or datetime types.

If one field is a string, Tableau cannot perform date calculations and will raise an error.