2 Replies Latest reply: Apr 17, 2012 3:59 AM by Ashok Chandran RSS

    Date variable in Formula

      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?