3 Replies Latest reply: Nov 9, 2018 5:36 AM by Anil Samineni RSS

    Date comparision based on User Entry

    ananda dhamodharan

      I have to compare 2 dates and get the result


      User will enter the Date1  : 02/05/2018

         

      EntryDate DueDateName
      01/05/1802/03/18aaaaa
      01/06/1802/06/18bbbb
      01/15/1805/20/18cccc
      01/30/1806/06/18ddddd
      02/02/1808/07/18eeee
      02/04/1806/22/18fffff
      03/06/1805/02/18dsesd
      05/06/1809/09/18mmmm
      05/23/1801/04/19rrrrrr
      06/22/1804/04/19ttttttt
      06/25/1809/09/20ssssss

       

      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.