Tableau Date and Time Functions

Date and Time Functions within Tableau.

A. YEAR:

DATEPART('year', [OrderDate])
 

This example extracts the year from the OrderDate column in the Sales table, providing the year value for each order.

B. MONTH:

DATEPART('month', [OrderDate])

This example extracts the month from the OrderDate column in the Sales table, providing the month value for each order.

C. DAY:

DATEPART('day', [OrderDate])
 

This example extracts the day from the OrderDate column in the Sales table, providing the day value for each order.

D. DATE:

MAKEDATE(2023, 6, 30)
 

This example creates a date using the specified year (2023), month (6), and day (30) values, resulting in the date "June 30, 2023".

E. TODAY:

TODAY()
 

This example returns the current date as of when the calculation is performed. It provides the current date dynamically.