Comparing two dates

[Aleksander_Rogo]

Hi!

I have a simple application to manage equipment servicing.

The equipment is periodically inspected.
I have written down i column DATE the final dates by which such service must be performed. I want to make a filter that will change the color of the row if the time from today to the final review is less than 6 months.

Can anyone help me with expression?

Thanks!

[Aurelien]

Hi @Aleksander_Rogo

@Aleksander_Rogo

I want to make a filter that will change the color of the row if the time from today to the final review is less than 6 months.

You may want to create a format rule here:

And use this expression in the format rule condition:

TOTALHOURS([finalReview]-TODAY())/24<(6*30)

Or, alternatively you can use this:

[finalReview]<EOMONTH(TODAY(), 6) + DAY(TODAY())

For reference:

EOMONTH() - AppSheet Help

TOTALHOURS() - AppSheet Help