KNOWLEDGE BASE

Calculating the End Date of Next Month


Published: 15 May 2017
Last Modified Date: 26 Jun 2017

Question

How to calculate the end date of the next month, similar to the eomonth function in Excel.

Environment

Tableau Desktop

Answer

  1. Create a calculated field named "First date of next next month" to define the first date of the next next month.
    DATE(DATEADD('month',2,DATETRUNC('month',[Date])))
  2. Create a calculated field named "End date of next month" to minus 1 day from "First date of next next month"
    DATE(DATEADD('day',-1,[First date of next next month])) 
    
Did this article resolve the issue?