2 Replies Latest reply on Jun 1, 2016 2:15 PM by Phat Luu

    Hide/Show Current Month based on a certain day of the month

    Phat Luu

      I want to my data to hide the current month if the current (Today or Now) date is before a set date within the current month.

       

      Example Scenario: It is currently May 12, 2016. I set the "Day current month data will show" date to May 15, 2016. My data will not show the month of MAY data until the current date is May 15, 2016.

       

      I'm currently using statement below to hide current month data.

       

      IF ( DATETRUNC('month',[Closed Date]) = DATETRUNC('month', NOW()) )

      Then "Display Current"

      ELSE

      "Does not Display"

      END

       

      Anyone got a suggestion on how I can add a "DAY" element to showing/hiding the current month?