Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Hi
Hope the attached file will be solve your doubt
Regards
Ashok
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.