Date range format on text conditional

[chrisschrade]

Hello - trying to set a conditional on a text element. The element is an expiration date, I’m trying to set the text color to yellow when the the current date is 90 days or less from the expiration.

I feel as if the range must be between Expir Date and Expir date minus 90 days - but the condition sentence doesn’t seem to end…see below, please help…thank you!

[emmanuel]

I don’t think you want to use Date Range here. What you want to say is "Expiration data minus current day: converted to days < 90.

[chrisschrade]

@emmanuel - That worked great…thank you