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?