2 Replies Latest reply: Apr 20, 2015 10:58 AM by Jannet San RSS

    How to write if condition in setexpression

    shiva ganguri

      Hi Friends,

       

      I want to display count of some ticketid based on difference of two date fields

       

       

      =Count(DISTINCT {<Process={'Change'},[Call_Day of Month]=,Call_Month=,Call_Year=>}

      if( Round ( Date(Date#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY') -Date(Max(Call_Date),'MM/DD/YYYY'))>= 0 and

      Round( Date(Date#([Scheduled Start Date Time],'MM/DD/YYYY hh:mm:ss TT'),'MM/DD/YYYY') -Date(Max(Call_Date),'MM/DD/YYYY'))  <=60,TicketID))

       

       

      Please suggest me..

       

      Thanks in Advance

      Siva