7 Replies Latest reply: Sep 30, 2015 1:27 AM by nagarjuna k RSS

    Restrict a data set based on date: What am I doing wrong?

    Jo Tedesco

      I think what is happening is:

      [date Start Tx] is working ok

      BUT

      DateFull - which I want because it is related to a Calendar - this is giving me ALL rows in the spreadsheet.

       

      How do I restrict the values of DateFull?  It must have something to do with being read into memory before the restriction takes place???

      Jo

       

       

      tableUse:

      LOAD    

      [date Start Tx],  

      [date Start Tx] as DateFull,   

      location 

       

       

      FROM

       



      [..\spreadsheet files\tableUse.xls]
      (
      biff, embedded labels, table is Sheet1$)

      WHERE
      [date Start Tx] >= '01/04/2015'
      // and [date Start Tx] >= 42095
      AND location <> 'East'
      ;

       

      Message was edited by: Josephine Tedesco I have attached the file, the date is unchanged but I have removed other columns and changed the ids Jo