4 Replies Latest reply: Jan 20, 2018 10:12 PM by Yeo Poh sai RSS

    How to compute the number of day from 2 date ?

    Yeo Poh sai

      Hi All


      I have below 2 expression :-


      Date(Date#([Opportunities Expected Close Date],'MM-DD-YYYY'),'MMM-YYYY') as [YearMth_EC],

      Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-YYYY') as [YearMth_CT],

         

      I need to compute the number of day duration for the above 2 date in number of day :-


      sum(

      Date(Date#([Opportunities Expected Close Date],'MM-DD-YYYY'),'MMM-YYYY') as [YearMth_EC],

      -

      Date(Date#([Opportunities Created Time],'MM-DD-YYYY hh:mm:ss'),'MMM-YYYY') as [YearMth_CT],

      )


      It does not work as above.


      CAn some one advise me.


      Paul