set analysis with date function

[souadouert]

I have

SUM({<DATE_PRODUCTION={'DATE(date#(DATE_PROD),'DDMMYYYY') <= $(=DATE_EXTRA)'}>}PRODUCTION)

in this part the experssion with red line (error)

[sunny_talwar · Accepted solution]

Replace the outer single quotes with double quotes and also add an equal sign

Sum({<DATE_PRODUCTION={"=Date(Date#(DATE_PROD), 'DDMMYYYY') <= $(=DATE_EXTRA)"}>}PRODUCTION)