Date variable in Formula

[#1]

I want to use a date variable in a formula. In the formula below I just want to show values where the date in field 'GELDIGTM' is greater than or equal to today's date:

Sum({<OFFERTE_GELDIGTM={">=$(DatumVandaag)"}>} OFFERTEREGEL_AANTAL * OFFERTEREGEL_PRIJS / OFFERTEREGEL_PRIJSPER * (1 - OFFERTEREGEL_KORTINGPERC))

When using the variable $(DatumVandaag) in a textbox the current date is shown correctly.

When I substitute $(DatumVandaag) with 17-04-2012 it works. With the variable I only receive 0-values.

How can I use this variable in this function?

[Anonymous]

Hi

     Hope the attached file will be solve your doubt

Regards

Ashok

[Anonymous · Accepted solution]

Hi

this is my sample set analysis same like your once and i got result too.

=Sum({<Date= {'>=$(=($(startDate)))'}>}Sales)

Using this you can easily find error in your set analysis query.

Regards

Ashok.