Conditional text color
How do I make a due date sitch to red once the date has pas?
i.e. if a a job is due 11/5/08, and today is 11/6/08 I want the due date filed to change to from default black to red
Molto Grazi Daniele!
(My Italian is not so good)
this worked perfectly!
I hadn't used conditional formating before!
You can use conditional formatting for the field DueDate.
Put this formula into the reserved space:
Get ( CurrentDate ) > Self
and set the text color to red.
but I'm not sure I'm following you here?
A little back...
which version of FileMaker do you use ?
We'll go on step by step.
You now have a date field named "DueDate".
1) Go to Layout Mode2)Select the field DueDate3) menu: Format >> Conditional... >> Condition >> Formula is : paste this:
Get ( CurrentDate ) > Self4) While there Format >> check Text Color and chose RED5) Ok6) Back in Browse Mode
Now try to enter a date into that field
Retrieving data ...