6 Replies Latest reply on Jun 11, 2018 6:37 PM by Shinichiro Murakami

    Days within a month between two dates crossing months

    Lauren McCollough


      I am trying to find a way to get the number of days between two dates (datediff) but grouping the day count by month. For example:

      ID A: Start date 1/1/2018  End date 1/15/2018  January days=15  February days=0

      ID B: start date 1/1/2018  End date 2/5/2018   January days=31  February days=5

      I have tried using a Level of Detail expression to fix the datediff at the month level but with no success. Any ideas?

      Thank you!