KNOWLEDGE BASE

How to Calculate the Date of the End of the Month


Pubblicato: 20 Dec 2023
Data dell'ultima modifica: 20 Dec 2023

Domanda

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

Ambiente

  • Tableau Desktop 2022.3+

Risposta

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]))))
Con questo articolo hai risolto il problema?