Use of If(Match) with multiple dates >= <=

[#1]

Dear all,

How can I use the dimension If(Match) with dates?

I know how to show a specific date, e.g. 02/02/2016. I managed by writing =If(Match(Orderdate, '02/02/2016'), Orderdate)

I now want all values between 02/02/2016 and 02/03/2016 so I should be able to use >= and <= in my formula or use something else than If(Match).

Can anybody help me?

Side note: I am not allowed to change anything in the script, so it should be solved within my used dimensions.

Thanks in advance!

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this: If(Orderdate >= '02/02/2016' and Orderdate <= '02/03/2016', Orderdate)

[#3]

Of course! I've used this before! I was confused by the use of if(Match) since I've been using that quite a lot lately.

Thans for your quick response!