Conditional Date Formatting

  • Thread starter Thread starter Craig
  • Start date Start date
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?
 
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
 
Back
Top