6 Replies Latest reply: Feb 24, 2016 4:35 AM by Manuel Mourin RSS

    Check if date is between two other

    Manuel Mourin

      Hi everyone,

       

      First, sorry for my bad english, hope you will be able to understand what I mean.

       

      I have some data and especially some date. I would like to have as dimension the time, from the early date (day by day) and count item when the date is between  the start date and the end date.

      Something like :

       

      count (Distinct If(item_date_start <= date_dimension <= item_date_end, 1, 0 )

       

      Actually, my dimension is the item_date_start.

       

      Thank You