Conditional Date Formatting

[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?

 

[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

 

[M Skabialka]

DateSub?? Try DateAdd instead.