access 2003 - expression builder - show a date is out of date

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

Guest

Can an expression be set up to take the date that is in the field and show
that it is out of date?
 
What does "out of date" mean?

You can build a query to pull all records where that date is before the
current date...
<date()

Or, you can use a similar criteria in your form's or report's conditional
formatting to have the date show in a different color if it is prior to
today.

Lots of options. You'd have to tell us exactly what you want to happen if
you need a more specific answer.
 
You must log in or register to reply here.

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

Recordset Findfirst Date Issue 0
Hello happy new year to all, Text box input for year of purchase 0
How do I get the date to display a Julian date? (yyddd) 2
Excel Excel Show Countdown Date 7
Date function in Forms 5
Field entry dependent on another field value 2
Date search query 0
Carry over date from previous record 1

Back
Top