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.
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...:-)