13 Replies Latest reply on Mar 10, 2016 9:21 AM by David Pires

    Date Ranges as a Month/Year

    David Pires

      Hi

       

      I need to come up with a solution for a date range problem.

       

      All our data is in months but in the database they are as date with the day set to the 1st of the month. Which means that if someone drags the bar for months but doesn't select 1st of that month, it will not show the data for that month, even though the filter label is showing correctly.

       

      Is there a way around this while keeping the range of dates filter? Can we somehow force the filter to land on the 1st of the month?

       

      I've attached a workbook with the example.

       

      Many thanks

       

      David