We would like to add a row style to a Generic Inquiry where if the SOOrder.OrderDate within 3 days of shipping AND SOShipment.ShipDate <= 3 days from the SOOrderDate show the row as ‘green40’ else show as ‘red40’. Unfortunately using Is Between can’t be used for the row style.
Best answer by lauraj46
View original
+7
Hi
Instead of ‘between’ you can just specify both conditions and combine with the ‘and’ operator, something like this:
=iif(datediff(‘d’, [SOOrder.OrderDate],[SOShipment.Shipdate])>=-3 and datediff(‘d’,[SOOrderDate],[SOShipment.Shipdate])<=3, ‘green40’,’red40’)
Hope this helps!
Laura
So far, so good. Thank you.
Thank you for your response, but now it gets a little more complicated. Here is the code
as we have it,
=iif(datediff(‘d’, [SOOrder.OrderDate],[SOShipment.Shipdate])>=-3 and datediff(‘d’,[SOOrderDate],[SOShipment.Shipdate])<=3, ‘green40’,’red40’)
and the added complication is if the SOShipment.ShipDate is < than the SOOrder.RequestDate. There are some instances where the SOOrder.RequestDate is in May, but the SOShipment.ShipDate is on the 29th of this month. If that has happened, then technically it should still be green, and not red.
+7
Hi
You can combine whatever criteria you like in the condition statement, just be careful with the parentheses for order of operations. Something like this may do it:
=iif((datediff(‘d’, [SOOrder.OrderDate],[SOShipment.Shipdate])>=-3 and datediff(‘d’,[SOOrderDate],[SOShipment.Shipdate])<=3) or [SOShipment.ShipDate]<[SOOrder.Requestdate]), ‘green40’,’red40’)
Hope this helps!
Laura
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
