Change "expired" to todays days. (01/01/03 format)

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi, I have a table with a date field. Some of the entries
have 'expired' in them. I would like to write a query to
display the table, and substitute the 'expired' with the
current date. Any thoughts?
 
Dear Mike:

Sounds something like this:

IIf(ColumnName = "expired", Format(Now(), "Short Date"), ColumnName)

Replace ColumnName with your actual column name.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top