Conditional Date Formatting


C

Craig

I need to conditionally format a form date field. Specifically, I
want to turn the field red with white bold text if the date displayed
is less than three months old. In a query it would be something like
DateSub("m",3,Now()) but that isn't working. I'm sure there is a
simple solution but I'm pulling a blank. Any suggestions?
 
Ad

Advertisements

B

Beetle

Use Conditioal Formatting. Use the Expression Is argument and then put;

[YourDateField] >= DateAdd("m", -3, Date())

Then set your formatting for the text and back color.

_________

Sean Bailey
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top