Conditional Formatting due dates

[SCP]

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

 

[Pete]

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()

 

[SCP]

Thanks - The condition 2 worked but not 1 -any ideas ??

 

[Douglas J Steele]

It should be DateAdd('m", -1, Date()).

 

[SCP]

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

 

[Pete]

Hi

Sorry for the typo in my previous post.

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

 

[SCP]

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

 

[Pete]

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())

 

[SCP]

That worked - Fantastic-Thank you so much
Tracey