4 Replies Latest reply: Feb 28, 2014 4:28 AM by Sahas Ullur RSS

    Date Variable in Where clause in load script

      Dear All,


      I need to put a where clause in load script.


      Example :

      LET vCutoffDate = makedate(2013);


      LOAD [Invoice Date], [Standard Invoice Qty], [Invoice Amount], [Cost Value], [Invoice #]


      Sales.QVD (qvd) WHERE [Invoice Date] >= vCutoffDate ;


      How to achieve this ? Your help is badly needed.


      Note : I do not want to change the SQL which is used to get data from DB using Select statement.