Checking to see if a date has past

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

I'm new at using Access. I have a expiration date in the data base, and I
need to check to see if that date is past due. If it is, I need to flag it
some way. I know how to do it in Excel, but not in Access. Any suggestions?
Thanks
 
You create a query that can then be run by itself or used as the basis of a
report. There are many ways to do this depending on your needs.

You could put something like below in the criteria of the date field of a
query. It will then return any record that is overdue.
Date()
Click to expand...

Or if the time is also important:
Now()
Click to expand...


In a form or report you could also use conditional formatting to change
overdueh dates to a different color or font.

For any of this to work properly, the field in question must be a Date/Time
data type. If it's a text field that looks like a date, it will take a lot
more effore to get it to work correctly.
 
Thanks Jerry, I'll give this a try.
--
Howard


Jerry Whittle said:
You create a query that can then be run by itself or used as the basis of a
report. There are many ways to do this depending on your needs.

You could put something like below in the criteria of the date field of a
query. It will then return any record that is overdue.


Or if the time is also important:



In a form or report you could also use conditional formatting to change
overdueh dates to a different color or font.

For any of this to work properly, the field in question must be a Date/Time
data type. If it's a text field that looks like a date, it will take a lot
more effore to get it to work correctly.
Click to expand...
 
Thanks Jerry. I'll give this a try.
--
Howard


Jerry Whittle said:
You create a query that can then be run by itself or used as the basis of a
report. There are many ways to do this depending on your needs.

You could put something like below in the criteria of the date field of a
query. It will then return any record that is overdue.


Or if the time is also important:



In a form or report you could also use conditional formatting to change
overdueh dates to a different color or font.

For any of this to work properly, the field in question must be a Date/Time
data type. If it's a text field that looks like a date, it will take a lot
more effore to get it to work correctly.
Click to expand...
 
Back
Top