Conditional formatting with dates

John thomas

Registered User.
Local time
Today, 03:44
Joined
Sep 4, 2012
Messages
206
Hi Help please
I have a continuous form that i use for tasks
i have a date opened box .I am trying to turn the box a differnt colour say amber if the opened date is more than one day old
and red if 2 days old
and brown after that
Just cant seem to get any sense out of it
 
An expression along the lines of

[FieldName] < Date()-2
 

Users who are viewing this thread

Back
Top Bottom