Conditional formatting date

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

Guest

Hello all

I have a field containing a date and want it to be formatted differently if
the date is prior to today (ie something is overdue).

I've tried setting conditional formatting to Expression is >today() but is
gives me a syntax error. Setting field value to less than today() doesn't
give an error but doesn't work!

Any ideas please?

Thanks in advance
Sue
 
Sue,
Use...
Field Value is Greater Than Date()

There is no Today function in Access. You can use Now() which returns
today's
date AND time, or Date() which returns just today's date.
 
Well, the fist thing I notice is that you say "less than" and ">". ">" is
greater than.

You should use field value and <Date()

BUT, your field must be a date for this to work. Is the field you are
evaluating a date type of field?
 
Hi Rick

Sorry, typing error with >, I did mean less than.

Thanks for the information about using Date(), which solves it nicely.

Best wishes
Sue
 
Back
Top