KNOWLEDGE BASE

Finding end of Month or End of Quarter Dates


Published: 06 Feb 2013
Last Modified Date: 21 Jul 2016

Issue

How to find end of month date or end of quarter date.  

Resolution

To find and use end of month date:
  1. Create calculated field with the following calculation: 
    DAY([Date] + 1) = 1
  2. Add calculated field to the filters shelf.
  3. Select True.
To find and use end of quarter date: 
  1. Create calculated field with the following calculation:
    DAY([Date] + 1) = 1 AND (MONTH([Date] + 1) = 4 OR MONTH([Date] + 1) = 7 OR MONTH([Date] + 1) = 10 OR MONTH([Date] + 1) = 1)l
  2. Add calculated field to the filters shelf.
  3. Select True.
Did this article resolve the issue?