MS Access97 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!!!
 
D

ddw_23

I am trying to convert a numeric date to a short date (ex. 20060424 to
4/24/2006). Thank you!
 
D

ddw_23

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.
 
D

Douglas J. Steele

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.
 
Top