1 Reply Latest reply on Jan 21, 2019 1:50 AM by Simon Runc

    Max Static Date

    shanmuga prabhu

      Hi All,

       

       

      Please let me know how to add max static date in text box .

      Example I have to show As of Date in text box and It should be static if any year selected

      If I have data from 01 Jan 2016 to 01 Nov 2018 , text box should show 01 Nov 2018 as static even if I select year 2017 or year 2016

       

       

      Thanks

        • 1. Re: Max Static Date
          Simon Runc

          hi Shanmuga,

           

          This Fixed LoD calculation will return the Max Date (and as a FIXED LoD is computed before any, regular, filters are applied. So even if the data is filtered down to 2016, it will still show the Max date in the data)

           

          {MAX([Date])}

           

          Hope that helps