Format Rule Date Greater Than

[AlejandroCamach]

Hi guys,

I’m trying to make a format rule so that the text highlights green if the deadline is further away than 2 weeks from today. The formula I’m using is DATE([Fecha de finalización]) > DATE(TODAY()+15) but still it doesn’t work.

Thanks for the help!

[LeventK]

@AlejandroCamacho
Are your columns Date or DateTime type?

[AlejandroCamach]

HI Levent,

Yes they are.

[LeventK]

Hello @AlejandroCamacho
Yes they are what? Are they DATE type or DATETIME type? Which one?

[AlejandroCamach]

Levent, there is only one column and is DATE type.

[LeventK · Accepted solution]

AlejandroCamacho:

DATE([Fecha de finalización]) > DATE(TODAY()+15)

Assuming that your Date column is [Fecha de finalizacion], than below expression will be more than enough to make the evaluation:

[Fecha de finalización] > TODAY() + 15

As your column is already a Date type, you don’t need to wrap your expression with DATE(…)

[AlejandroCamach]

Thanks Levent, but I already tried that, it does not work. What else do you think it might be?

[Lynn]

Hi @AlejandroCamacho Do you have a screenshot of your format rule page?

[AlejandroCamach]

Hi Lynn and Levent, I had a mistake in the date… so do not worry, the formula Levent made works fine. Thank you so much!