Conditional Format 1

[hdat44]

How do i set a conditional format to show dates that are due to expire within the next 3 months. i can set it for 91 days but not sure how to do 3 months??

 

[PHV]

i can set it for 91 days
How did you that ?
Have a look at the DateAdd function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hdat44]

Field Value is less than Now ()+91 days

 

[PHV]

Field Value is less than DateAdd("m", 3, Now())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hdat44]

That worked!!! many thanks