7 Replies Latest reply: Nov 18, 2014 11:12 AM by Oscar Ortiz RSS

    why i must have this line ? Date(Monthstart([date_time]), 'YY MMM') as test1;

    Yeo Poh sai

      Hi All

       

      I have below code which is running fine :-

       

      CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=andonDatabas;Data Source=Paul;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PAUL;Use Encryption for Data=False;Tag with column collation when possible=False];

       

      LOAD

      *,

      Date(Monthstart([date_time]), 'YY MMM') as test1;

      select * from record_produksi_plc;

       

      when i try to remove below code from above :-

       

      Date(Monthstart([date_time]), 'YY MMM') as test1;

       

      I will get error.

       

      what should i do ? if i want to remove above line and not get error ?

       

      Paul