I just wrote a row style --
=Iif ([SOOrder.CustomerRefNbr] = 'PRO FORMA' and [SOOrder.Status] = 'R','red20', 'default')
If it’s a PRO FORMA on CREDIT HOLD, highlight the row red. So far so good.
I would like to modify this so it’s only on credit hold pro formas that are greater than a week old. So I did something like this:
=Iif ([SOOrder.CustomerRefNbr] = 'PRO FORMA' and [SOOrder.Status] = 'R' and [SOOrder.OrderDate]< @Today -7,'red20', 'default')
That unfortunately gives an error. Is there a way to do dates in expressions? I see the DateDiff function but I have no idea how to work the syntax on that. Thanks!
Best answer by darylbowmanView original