6 Replies Latest reply: Jun 13, 2013 7:24 AM by Selvakumar S RSS

    Difference between two Dates

      Hi All,

       

      I need to find the difference between two dates. For this i used this expression below

       

       

      (

      dayStart(timestamp(END)) - dayStart(timestamp(START)))

       

      but how to include the Start and end date also while subtracting

       

       

      For Example: 

       

      START Date: 24-Feb-2013  and END Date: 2-Mar-2013

       

      If i used the above expression, Result is : 6

       

      But i need the result as 7 (24,25,26,27,28,1,2)

       

      Any idea?

       

      Thanks,

      S.Selvakuamr