Issue with conditional formatting for date

[Phillipc1]

Hello All!

I am having an issue where I am wanting my report to highlight all expired dates and any dates within 7 days of now. However, my formatting is returning all dates back highlighted. What am I doing wrong?

[June7]

Rule works for me. Although, I would probably use Date() instead.

However, your field looks like a text field not a date/time type. In which case the expression will not work because field does not contain a true date value, just a string of characters. Sometimes Access will do implicit data conversion but not in this case.

Either change the field type in table or deal with the data conversion (same goes for DOTDate). Instead of Field Value Is, use Expression Is and try:

CDate([ExpirationDate])<= Date() + 7

[Phillipc1]

Awesome, I utilized the CDate expression and that worked. I appreciate it!