Hello all,
Can you help me in building up the logic in coloring the rows of a GI where if the Date is due in the next 2 days it should turn the row as orange.
I have applied the logic as below:
Date<=Today()+2, ‘orange’
where upon running the GI it throws the error for system cannot convert +2 system.int.
How to resolve this?
Best answer by Rakshanda
hi
use like DateAdd('d', -2, Today())
hope above helps !!
Hi
In Generic Inquiry, add this code in the Row Style section.
=IIf(DateDiff('d', Today(), [SOOrder.orderDate]) >= 0 And DateDiff('d', Today(), [SOOrder.orderDate]) <= 2, 'orange', 'default')For OrderDate, replace it with the field you need.
If you want to change the row color, add the row style to the header.
This should address your requirement.
Hi
You can also try this approach as an alternative:
=IIf([Table.DateField] <= DateAdd(Today(), 'd', 2), 'orange', 'default')Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.