Conditional Formatting Issue

[sherry.hodges]

I am trying to complete what should be a very simple conditional format, but for some reason Access 2010 is not reading my dates correctly.

I have to condition <than today, today + 30, between 30/60 days and between 60/90 days. Access is not reading the year, i.e. it is picking up the year 2013 in the < Date() and picking up the 2013 year in the 30/60 days.

What could be the problem.

Thanks!

 

[pr2-eugin]

Did you happen to check your System Clock if it is set properly??

 

[sherry.hodges]

Yes it is correct.

 

[pr2-eugin]

Could you show the condition that you have used?? Code snippet?

 

[sherry.hodges]

Value < Date() format Red
Value Is Between Date() and Date() +30 format Blue
Value Is Between Date() +30 and Date() +60 format Yellow
Value Is Between Date() +60 and Date() +90 format Green

Thank you!

 

[pr2-eugin]

Is that the code you have implemented..

How about using the DateAdd() Function to add the dates.. It is so much easier and always produces the correct values.. Adding integer sometimes adds to the month of the date as you know sometime the format of date is mm/dd/yyyy..

DateAdd(interval, number, date)

 

[sherry.hodges]

No code just the conditional format rules manager: used the DateAdd It worked Thank you!

 

[pr2-eugin]

You are welcome.