Help needed: why this complex expression on date calculation not working?

[chrisjiang]

I want to create a reminder to assigned user before "endDate" and I tried this complex expression. But it does not work ("endDate" is a field of Date, not Datettime), why?

And it seems this does not work only with the "equals" choice, it works well with "less than or equal" etc.

Please help. Thanks.

Chris

[yuri]

Hi Chris,

Instead of "DATE" function try w/o a function.

[chrisjiang]

If I do not try Complex expression, there is no choice on choosing an Exact match of, say,  3 days before field "endDate". It will come with a range of period instead of a specific date.

[Maximus]

Hello Chris,
try to write formula this way "datetime\date(datetime\addDays(datetime\today (), 2));

[chrisjiang]

Hello Chris,
try to write formula this way "datetime\date(datetime\addDays(datetime\today (), 2));

Hi Maximus,

This does not work.

Thanks anyway.

[chrisjiang]

Hi Chris,

Instead of "DATE" function try w/o a function.

Can you please explain more in detail? Thanks so much!

[chrisjiang]

Hi Chris,

Instead of "DATE" function try w/o a function.

After trying finally your way works, thanks so much!!

I would like to attach the following screen shot for others' reference: