Skip to Content
0
Former Member
Dec 20, 2007 at 09:19 PM

output a text value from formula in query designer

1193 Views

I need to display different text values in a query. For example, if actual delivery date falls within 5 days of planned delivery date, display 'ON-TIME'; if earlier than 5 days display 'EARLY', if later than 5 days display 'LATE', etc. I've been researching this to death. Does it have to be a customer exit variable or is there a better way to do this?

thanks!