Setting a pre-warning via dates

Hi folks,

I’m looking for a quick answer really.

I have a field for Insurance Date.

What I want, is 5 days prior for a yellow icon to appear. After them 5 days, it should turn red to signify it has expired. I have achieved the red icon appearing to signify it expiring, however I am struggling with the yellow icon.

I can get it to appear 5 days before the insurance is due to end, however it will remain until the insurance is due. Here is my condition. Could anyone help?

image

Similar to what you have done for the red icon.

Show the yellow icon when -

insurance date +(days) -5 <= Current Date/time

Ankur@ Nocodetalks
Looking for a Bubble Coach? Check out here

1 Like

I found a way around it, but this also works in case anyone has the same issue! :slight_smile:

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.