Format Rule Date Greater Than

AppSheet AppSheet Q&A
,
1

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!

2

@AlejandroCamacho
Are your columns Date or DateTime type?

3

HI Levent,

Yes they are.

4

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

5

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

6

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(…)

1 Like
7

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

8

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

1 Like
9

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!

2 Likes