If you put the red condition first, if it is > 14 days old it will pass, bit so will the blue condition, and the second will take preference unless you tell the CF to stop on true.
Best to put the blue condition first, red second.
If you put the red condition first, if it is > 14 days old it will pass, bit so will the blue condition, and the second will take preference unless you tell the CF to stop on true.
Best to put the blue condition first, red second.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Cond. #1 =(O5-TODAY())>7 (Blue)
Cond. #2 =(O5-TODAY())<7 (Red)
My god to many days in VB coding can make you go insane lol
Thanks guys it's working now.
I need a refresh course
Posting Permissions
Reply With Quote