Date box popup or goes red when date expires (-14 days)

[ttmail]

I need a function or script so that the date box goes red or there is a popup that says that my domain expires in 14 days.

 

Easy explanation would be helpful as I am new to Filemaker.

 

Thanks

 

 

[Aussie John]

you could use a conditional format rule to make the field red

[Lee Smith]

There are a couple of different ways to do this. You can create a "Flag" field or use the Conditional Formatting as suggested by John.

 

I slapped together a demo showing how you can use the Self or a Calculation.

 

ttmail.fmp12.zip