Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Perhaps like this: If(Orderdate >= '02/02/2016' and Orderdate <= '02/03/2016', Orderdate)
Perhaps like this: If(Orderdate >= '02/02/2016' and Orderdate <= '02/03/2016', Orderdate)
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!