"Greater than" in set analysis not working

[Anonymous]

Hi

I have this problem with a expression where it doesn't work when I'm using "Greater than" calculation.

But when I'm only using "Equal to" it works perfectly.

So when using below it works without problems:

SUM({< BOOKING_DATE = {'22-06-2017'} >} Sales)

But  when I'm using below it doesn't work:

SUM({< {< BOOKING_DATE = {">=$('15-05-2017')"} >}  Sales)

When I'm doing the same thing with another date variable, INSERT_DATE, it works perfectly. So can it be something with the setup of the BOOKING_DATE?

However, if I make the BOOKING_DATE as a Listbox and I choose the dates directly it works. So I guess the date i configured correctly?

I hope someone can help me.

Stefan

[MK_QSL · Accepted solution]

use

SUM({<BOOKING_DATE = {'>=15-05-2017'}>}Sales)

Here I am assuming that BOOKING_DATE is in DD-MM-YYYY format

[Anonymous]

So simpel, and yet so useful!

Thanks a lot Manish.

Stefan