4 Replies Latest reply: Oct 16, 2013 11:41 AM by Sudeep Mahapatra RSS

    Load Script - Date Issue

    Jerry Lau

      Hi all, please advise what's wrong with the following script, thanks!

       

      LET vYesterday=MakeDate(2013,10,12);

       

      [VBAK]:

      LOAD

         VBELN,KUNNR,BSTNK,

         VKGRP,VKORG,VTWEG,

         SPART,AUDAT,VDATU,

         AUART,WAERK,KNUMV,

         FAKSK,ERNAM,VKBUR,

         KTEXT,ERDAT,ERZET;

      SQL Select

         VBELN KUNNR BSTNK

         VKGRP VKORG VTWEG

         SPART AUDAT VDATU

         AUART WAERK KNUMV

         FAKSK ERNAM VKBUR

         KTEXT ERDAT ERZET

      from VBAK WHERE

         Date(ERDAT,'dd/MM/yyyy')='$(vYesterday)';

       

      /QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 Comma without preceding colon (after OPEN ?).)