Using "TODAY()" in Access 2000

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

Guest

I want Access to highlight a date field that is older than today. When I
type in the Conditional Formatting box less than TODAY(), Access does not
recognize the function. How do I get Access to highlight a date field that
is older than today without going into design view everyday and manually
inserting today's date in?
 
On Thu, 25 Nov 2004 02:31:04 -0800, "Steve Petro" <Steve
I want Access to highlight a date field that is older than today. When I
type in the Conditional Formatting box less than TODAY(), Access does not
recognize the function. How do I get Access to highlight a date field that
is older than today without going into design view everyday and manually
inserting today's date in?
Click to expand...

TODAY() is a function in Excel. The corresponding function in Access
is Date().

Let's have a cheer for Microsoft being consistant, and for cleaning up
the Help file indexing so the Help actually refers to the program
that's running... <sour grin>

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top