What is the difference between Tableau’s DATETRUNC() and DATEPART() functions?

Question

Tableau — Hard

What is the difference between Tableau’s DATETRUNC() and DATEPART() functions?

Accepted Answer

The distinction between DATETRUNC() and DATEPART() lies in their output: DATETRUNC() returns a full date value, while DATEPART() extracts a specific numeric component. This difference is crucial for accurate date manipulation. Incorrect options misrepresent the functions' purposes.