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!
@Aleksander_Rogo wrote:
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:
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |