13 Replies Latest reply: Dec 15, 2017 11:08 AM by omar bensalem RSS

    Load * from excel files only when the excel file contains today's date

    omar bensalem

      Hi all,

       

      I'm trying to load every excel file in a folder where the excel file contains today's date-1

      my excels are as follow:

      Capture.PNG

       

      what I've done is the follow:

      table :

      let D1=  date(Today()-1,'DDMMYYYY');

      FOR Each Ext in 'xlsx'

        FOR Each File in filelist ('lib://Test/'&'\*.'&Ext)

      Concatenate

      load  *  Where left(File,8) ='$(D1)'  ;

      next File


      What am I missing please?