1 Reply Latest reply: Jun 11, 2013 7:44 PM by Lee Matthews RSS

    Data Load with customer function

    Josh Duenyas
      Hi All
      Is it possible to call a custom function which I have built into the VB Module to evaluate elappsed time between dates into a field at Load time?
      Also, is it possible to use the function in an expression?
      LOAD
      ProjectEngineerID,
      EmailReceivedOn,
      QuotedOn,
      TimeCard(EmailReceivedOn,QuotedOn) AS ElapsedTime;
      SQL SELECT *
      FROM QDB.dbo.vuPESTATS;

      The TimeCard is the cutome function which I have built. (Sample file is attached)

      Running the function in the VB Module works OK but no values are returned during the load time.
      Thanks
      Josh