Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I use a variable called vToday that contains a date e.g. 06.08.2009
I tried this:
sum({$<Datefield = {"$(vToday)"}>} Sales)
This isn't working.
If I use sum({$<Datefield = {">=$(vToday)"}>} Sales), it I'm getting the correct sum.
can someone please tell me why the first approach doesn't work. Thanks
Aloah
May I suppose that it is a problem with the date format? To be sure pls check.
I cannot reproduce it, though if I use 06/08/2009 it works perfectly right with both your expressions. With your 06.08.2009 behaves strange.
Flavio