5 Replies Latest reply: Jan 22, 2016 12:35 AM by Hasvine Dhurmea RSS

    Min and Max date

    Hasvine Dhurmea

      Hello All,

       

      Could you please help me correct the below:

      The mistake is by the "RESIDENT MSMEDIA" (In bold and underline)

       

      MSMEDIA:

      LOAD ID,

          CampaignID,

          QueueID,

          UniversalTime,

          UniversalTimeString,

          AgentID,

          AgentOid,

          AgentLocalTime,

          LocalTime,

          Date(Floor(AgentLocalTime)) as Date_prise_en_charge,

          Date(Floor(LocalTime)) as Date_Reception,

          AgentUniversalTime,

          AgentUniversalTimeString,

          Time(Time#(WorkDuration,'ss'),'hh:mm:ss') as WorkDuration_1,

          Time(Time#(WrapupDuration,'ss'),'hh:mm:ss') as WrapupDuration_1;

      SQL SELECT *

      FROM "HN_MediaServer".dbo.MSMedias WHERE CampaignID='E4136357942437B4';

       

       

      MinMaxDate:

      LOAD

          Min(AgentLocalTime) as MinDate,

          Max(AgentLocalTime) as MaxDate,

         

      Resident MSMEDIA;

       

      LET vMinDate=floor(peek('MinDate'));

      LET vMaxDate=floor(peek('MaxDate'));

       

      Drop Table MSMEDIA;

       

       

       

      Many Thanks,

       

      Hasvine