Today formula

[asknyldz]

Hi there,

I want to today date in my formula instead of 01/05/2016

(sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]),MONTH={'<=01/05/2016'}*P(MONTH)>-<CLIENT={'NEW CLIENTS','EXPANDED CLIENTS','FORECAST ADJUSTMENT'}>}AMOUNT))/1000

Thank you

[sunny_talwar]

I hope that MONTH field is actually a date field, else this is not going to work. If it isn't use a date field here

(Sum({<TYPE={'ACTUAL'},BUSINESS={'NEW','EXPANDED'}*P([BUSINESS]), DATE={"<=$(=Today(), 'DD/MM/YYYY')"}*P(MONTH)>-<CLIENT = {'NEW CLIENTS', 'EXPANDED CLIENTS', 'FORECAST ADJUSTMENT'}>}AMOUNT))/1000