2 Replies Latest reply: Oct 23, 2018 8:06 AM by Kingsley Hoare RSS

    Dates Help in backend

    Mahitha M

      Hi Experts,


      Can any one please help me on below requirement.

      I have the source like below



      Load * Inline [


      Banking,4586A,05/10/2018 00:00:00,08/10/2018


      Crime Analytics,5793B,25/07/2018 00:00:00,

      Crime Analytics,8794B,13/07/2018 00:00:00,


      HR,48632E,12/09/2018 00:00:00,13/09/2018

      HR,58632E,05/08/2016 00:00:00,

      HR,68632E,09/06/2018 00:00:00,


      Service,8632O,03/09/2018 00:00:00, 06/09/2018

      Service,86321,01/10/2018 00:00:00, 04/10/2018



      In the below input we have 8 rows. Here I need to keep only the rows where both startdate and enddate is not blank  by using backend script.

      Please help me on this.

      Please find the below attached app.

      Thanks in advance



      Expected output

      expected output.png