4 Replies Latest reply on Apr 11, 2013 5:04 AM by Zubair Aleem

    days between dates with missing values in calculated feild

    Zubair Aleem

      I would like to work out the number of days between dates,

       

       

      Using this formaula does not give fill in the missing dates hence does not give the true number of days. I have trind window_max and Window_min but still unable to get the correct number of days on qtr/month/year date dimension.

       

      datediff('day',min([DateTime],max([DateTime])

       

      Is ther a way to create a default Date