topic Re: Date variable in Formula in Water Cooler

Date variable in Formula

Tue, 17 Apr 2012 07:45:40 GMT

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?

Re: Date variable in Formula

Anonymous — Tue, 17 Apr 2012 07:56:52 GMT

Hope the attached file will be solve your doubt

Regards

Ashok

Re: Date variable in Formula

Anonymous — Tue, 17 Apr 2012 07:59:59 GMT

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.