I need help with the above function.

 

I have a database with companies. In the date box for when the accounts are due say 01/01/2013 - If the date goes past this date then I want the box to change to red. Example when the date goes to 02/01/2013 then the boxes turns red.

 

Hope someone can help as I am new to filemaker.

 

I am using Filemaker 10.

 

Thanks for any help.

 

 

 

 

 

 

Click on the Date box

 

Go to Format->Conditional on the Filemaker status bar

 

then give the condition i.e if the ( >expiry date)

 

Fill color red.

Is that in the "formula is" line and what would I put is ?

 

Sorry for asking but I am not very good with this

Yes