4 Replies Latest reply on Jan 10, 2019 5:20 AM by Devin Smith

    Days of the month with missing data

    Devin Smith

      Good Afternoon All,


      I am trying to work out the total number of days in a month however I have a problem, on certain days there is no data which then affects the following calculated field:


      DATEDIFF('day',DATETRUNC('month', [Business Date]),DATETRUNC('month', dateadd('month',1,[Business Date])))


      The calculated filed uses my 'Business Date' column however when there is missing data the business date is obviously not there which then affects the above,


      I want to calculate the days in a month regardless of whether there is data or not,


      Many Thanks