MS Access97 Date

  • Thread starter Thread starter ddw_23
  • Start date Start date
D

ddw_23

Hi Everyone.
I'm trying to change a numeric date into a short date. Can someone
assist me PLEASE??
Thanks to all in advance!!!
 
I am trying to convert a numeric date to a short date (ex. 20060424 to
4/24/2006). Thank you!
 
I'm sorry, I didn't make myself clear. I imported text into a database.
The date field for all the records are in "text" format based on the
table's design view of Access97. In my query or report, I want all the
records to show a short date format vs. numbers like 20060424,
20060425, 19990101, etc. I can't change it in my table's design because
I loose the data in that field. Thanks.
 
Create a query based on the table, and plug that formula into the query as a
computed field.

Use the query wherever you would otherwise have used the table.
 
Back
Top