7 Replies Latest reply: Oct 4, 2010 5:56 PM by Sheila DeLaney RSS

    create Time from field called WMSTransactionTime

       

      trying to make fields HH MM SS from the word WMSTransactionTime - but having a little bit of an issue. Can someone please tell me if I am on the right track?

       

       

      maketime(left(SH_Time,2), mid(SH_Time,3,2), right(SH_Time,2)) as [WMSTransactionTime],

       

      Load

      WMS_TransactionTime as WMS_TransactionTime,

      Hour(WMS_TransactionTime) as WMS_TransactionTime_Hour,

      Minute(WMS_TransactionTime) as WMS_TransactionTime_Minute,

      Second(WMS_TransactionTime) as WMS_TransactionTime_Second;

       

      receive the following message during debug

      Table not found
      Store WMS_TransactionTime into ..\..\QVD\WMS_TransactionTime_Transform.qvd (qvd)

       

      is the message because the fields are blank?