Error when using dates in a KPI expression

[Evan0211]

I have a KPI that checks against various conditions, one of which is if a date falls before a variable date.  The expressions is written as:

<[ULTIMATE_COMPLETION_DATE]={"<=$(=Date(today()+$(vDays_Remaining_Variable_Input)))"}>

This expresses to:

<[ULTIMATE_COMPLETION_DATE]={"<=3/2/2042"}>

(the default is set to 7300 days for testing purposes).

However, the KPI resolves to zero.  If I remove the line above (<[ULTIMATE_COMPLETION_DATE]={"<=$(=Date(today()+$(vDays_Remaining_Variable_Input)))"}>) the KP resolves to 30, which is correct, so there is an issue in that line.

My guess is that [ULTIMATE_COMPLETION_DATE] needs to be converted to a Date, but that isn't working.  Any advice?

[Evan0211 · Accepted solution]

I found the issue.  I was using Date() instead of TimeStamp().