4 Replies Latest reply: Jan 26, 2018 12:18 PM by pradosh thakur RSS

    Max Date based on a filter date

    zahid Rahim

      Dear Experts,

       

      I have a column with dates. There is a separate date filter. I want to show Max Date from dates column based on the date selected in the filter.

       

      If the user select 31-DEC-2017 then it restrict the dates till 31-DEC-2017 and show the maximum date from first day till 31-Dec-2017.

      If the user select 30-NOV-2017 then it restrict the dates till 30-NOV-2017 and show the maximum date from first day till 30-NOV-2017.


      Suppose Date is in vDate and dates column is plan_start_date.


      Regards,


      Zahid Rahim