KNOWLEDGE BASE

How to Calculate the Date of the End of the Month


Veröffentlicht: 20 Dec 2023
Zuletzt geändert am: 20 Dec 2023

Frage

How to get the date of the end of a month.
 

Umgebung

  • Tableau Desktop 2022.3+

Antwort

Because there is no native date function to determine the end of the month from a date field, create a date calculation as instructed below to obtain the end of the month. 

DATEADD('day',-1,(DATEADD('month',1,DATETRUNC('month',[Order Date]))))

Zusätzliche Informationen

Vote on the Tableau Community Idea to have a default function added to the product.
Hat dieser Artikel das Problem gelöst?