1 Reply Latest reply: Aug 27, 2018 7:34 AM by Olivier GAUTIER RSS

    help on below requirement?

    daisy ch

      Hi

       

      I have table and completion_date and Id and newdate fields is there.

       

      [Completion Date],ID

       

      10-jun-2017,   10

       

      11-July-2017,  20

       

      20-Aug.-2018,  30

       

      9-dec-2018,     40

       

       

       

       

      My requirement is

       

      When I select date from newdate field and completion_date equal to 100% than calculate the 25,50,75,100% what are the id and completion_date available under 25,50,75,100% display in table .

       

      EX: required Output

                    Completion_date             value

       

      25%         10-jun-2017                      1

      50%          11-july-2017                     2

      75%          20-aug-2018                     3

      100%        09-dec-2018                     4

       

      the above output value field is position of the date and above table I have taken only 4 records .if in case 1500 records is there and 1500 records dates equal to 100% and calculate 25,50,75 100 % .

       

      in that 1500 records find the 25% and which   id and completiondate available at 25% and same way 50 ,75,100.

       

      Please help on this if have any idea.

       

      thanks.