8 Replies Latest reply: Jul 22, 2016 2:43 AM by Chris Neumann RSS

    Script where Today is between Start and End Date

    Chris Neumann

      Hi Guys

       

      I need a script to return the only the record for:

      where Today() is between Start Date Key and End Date Key

      So the Table will be reduced based on one Coy No Record where Today(20170720) is between (Start Date Key and End Date Key)

       

      Script dummy:

      CompanyNumber:

      LOAD [Coy No],

           [Start Date Key],

           [End Date Key]

      FROM

      Between.xls

      (biff, embedded labels, table is Sheet1$);

         

      Coy NoStart Date KeyEnd Date Key
      1111112016080199991231

      111111

      2016070120160731
      1111112016053020160630
      1111112016051020160529
      1111112016050120160509
      1111112016040120160430
      1111112016032020160331
      1111112016030120160319
      1111112016020120160229
      1111112015121220160131
      1111112015120420151211
      1111112015112420151203
      1111112015112320151123
      1111112015111720151122
      1111112015100920151116
      1111112015090720151008
      1111112015072520150906
      1111112015062920150724
      1111112015050720150628