IF (DATEDIFF('month',[Order Date],[select date parameter])<13 AND
DATEDIFF('month',[Order Date],[select date parameter])>=0) THEN 1 ELSE 0 END
Thank you for your answer.
Actually, it works for the limitation of 13 months.
But the user still can select in the filter a period of 14, 15 months.
I think, i'll do this and display a message if the date filter take more than 13 months.
Hi Shashi and thanks.
If the user want to select only the month of january of 2017. It is not possible with this filter because it depends of one anchor date who is not dynamic.
Maybe i'm wrong ?