Filter expression not working

[rcaesar]

Folks

I have this  expression in a report that isn't working. I am trying to use this in a conditional formatting on the [ENDNG_DT] column.
What I am trying to get is the number of days between, and use those in a conditional format.

It gives me an error data asychronous, and also thinks that the >= and <= are incorrect

([ENDNG_DT]>=(current_date) AND [ENDNG_DT]<=(_add_days (current_date,120)))

This used to run in version 10.

I am using ver 11.04

Any help is much appreciated.

[rcaesar]

Folks,

I think I resolved the issue. I first had to cast the date as a timestamp. To get [EndDate] >= CurrentDate I had to use _days_between ([EndDtCast],[CurrntDtCast])>=0.

Realized too late that I just couldn't use [EndDate] >= CurrentDate.

Learn something everyday...:-)