4 Replies Latest reply: Aug 5, 2014 8:27 AM by Manish Kachhia RSS

    find the difference of dates

    Mark Munich

      Hallo Qlik community,

       

      I have 2 diferent date fields, I have calculate the max of date field and min of other date field. now the Problem is i want to find the difference between These 2 fields.

       

      for example I am using the following formula, but is not returning the right date.

       

       

       

      differencetime=interval((max(Enddate)),(min(Startdate)))

       

       

      any suggestions.