Question
How to get the date of the end of a month.
Last Modified Date: 20 Dec 2023
Environment
- Tableau Desktop 2022.3+
Answer
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]))))
Additional Information
Vote on the Tableau Community Idea to have a default function added to the product.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials
Trending Articles
Results 1-3 of 50