1 Reply Latest reply: Nov 9, 2018 5:37 AM by Anil Samineni RSS

    date comparision based on user entry

    jaya19 dh

      I have to compare 2 dates and get the result

       

       

       

       

      User will enter the Date1  : 02/05/2018

       

       

                                                                       

       

       

      EntryDate  DueDate Name

      01/05/18 02/03/18 aaaaa

      01/06/18 02/06/18 bbbb

      01/15/18 05/20/18 cccc

      01/30/18 06/06/18 ddddd

      02/02/18 08/07/18 eeee

      02/04/18 06/22/18 fffff

      03/06/18 05/02/18 dsesd

      05/06/18 09/09/18 mmmm

      05/23/18 01/04/19 rrrrrr

      06/22/18 04/04/19 ttttttt

      06/25/18 09/09/20 ssssss

       

       

       

       

       

       

      I have to find which name belongs to this below condition if the user enter the  Date1  : 02/05/2018

       

       

               

       

       

      Entry Date <= Date 1 

      Due Date >= Date 1 

       

       

                        

       

       

      what is the best way to handle.I tried with Getfield selection for capturing the user entry and compare the values .It didn't work.

       

       

       

       

       

       

       

       

      Advance Thanks for your help.