Skip to main content

I’m trying to use this formula to tell me if an item is in our inventory or not based on the delivery date. If the delivery date is before today, it’s no longer in our stock.

IF(IS_AFTER({Delivery Date}, TODAY( )), “Yes”, “No”))

This formula is giving me an error and I can’t figure out why. Is the formatting wrong? Is there any other way to accomplish this?

Basically, I want the output to be “Yes” if the {Delivery Date} is after today, and “No” if it’s before today.

I think you’ve got a bracket “too much” at the end of your formula

IF(
	IS_AFTER({Delivery Date},TODAY()), 
	"Yes",
	"No"
)

I think you’ve got a bracket “too much” at the end of your formula

IF(
	IS_AFTER({Delivery Date},TODAY()), 
	"Yes",
	"No"
)

Oh my God! So simple. Thank you. I thought I had tried everything.

Terms & ConditionsAccessibility statement