Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use
SUM({<BOOKING_DATE = {'>=15-05-2017'}>}Sales)
Here I am assuming that BOOKING_DATE is in DD-MM-YYYY format
use
SUM({<BOOKING_DATE = {'>=15-05-2017'}>}Sales)
Here I am assuming that BOOKING_DATE is in DD-MM-YYYY format
So simpel, and yet so useful!
Thanks a lot Manish.
Stefan