Conditional Formatting due dates


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
 
Ad

Advertisements

G

Guest

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

Guest

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
 
G

Guest

Hi

Sorry for the typo in my previous post.

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

Advertisements

G

Guest

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

Guest

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top