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

    Time range

      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:



      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,