5 Replies Latest reply: Jun 13, 2013 3:10 PM by Ramakanth Vanga RSS

    Reading the minimum value of a date.

      Hi,

       

      I have issues in using Min function to read a lowest date.

       

      For a given quarter and fiscal year, I have all the dates for that quarter and need to find the start and end date of that quarter. My list box is displaying all the dates of the quarter and when I tried to use Min function, it doesn't display a record.

       

      Following is my expression.

      =if(GetFieldSelections(Years)=FISCAL_YEAR

      and GetFieldSelections(Quarters)=FISCAL_QUARTER_NAME,Min(FISCAL_DATE))

       

      If I remove Min(FISCAL_DATE) and use Fiscal date, it gives me all the dates of the quarter as below.

      screenshot.jpg

      Any help is appreciated.

       

      Thanks

      Ramakanth