Conditional Formatting due dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field called "Expiry date" that I want to set a format to (change
colour etc)when that date becomes within a month of expiry and when has
expired. I have looked at a response to a similar question but couldnt get
that to work.
Many Thanks
 
Try the following:
Condition1 (Within 1 month)
Field Value Greater than or equal to DateAdd("mm",-1,Date())

Condition 2 (Expired)
Field Value Greater than or equal to Date()
 
Thanks very much -that seemed to work BUT -is colouring all dates , even 2007.
I only want it to apply to probably 1 month ahead of the expiry date.
Sorry to be a pain
 
Hi

Sorry for the typo in my previous post.

Condition 2
Field Value is between DateAdd("m",-1,Date()) and DateAdd("m",1,Date())
 
Thanks. The condition 2 is ok but can't get condition 1 to play. It is making
all dates that havent expired into the format where I only want upcoming
dates.---Sorry
I "copied & pasted" your answer in but don't know whats wrong ??
 
Try swapping Condition1 and Condition 2 around ie.

Condition 1
Field Value is between DateAdd("m",-1,Date()) and DateAdd("m",1,Date())

Condition 2
Field Value Greater than or equal to DateAdd("m",-1,Date())
 
Back
Top