5 Replies Latest reply: Jun 30, 2015 4:32 AM by Hasvine Dhurmea RSS

    Time range

    Hasvine Dhurmea

      Hello Guys,

       

      I have an issue I need to load data from a specific time (from 04:00:00 to 15:00:00).

       

      In my load script in my call table i used the below:

       

      Load

      Time(subfield(CallUniversalTime, ' ' ,'hh:mm:ss')) as Time,

       

      SQL SELECT *

      FROM "HN_Ondata".dbo.ODCalls where FirstCampaign = '1743'and Time > '04:00:00' and Time < '15:00:00';

       

      However, it does not work.

       

      Any idea?

       

      Thanks for your help.

       

      Kind Regards,

       

      Hasvine