Newbie with UPDATE question

T

Tolga Uzuner

Hi There,

First of all, apologies if this is too simple a question.

I have a table which has a column called date. However, the format is
not "Date" but "Text" and is of the form yyyy_mm_dd, as the data was
imported from a text file with that format.

I wish to convert the data into proper date format. I am guessing that
UPDATE is what I need to use, but can't figure out how. I am using MS
Access 2003.

Any pointers appreciated.

Many thanks in advance,
Tolga
 
D

Duane Hookom

You might want to look at the recent message with a subject of "How do i
convert yyyy_mm_dd strings to proper dates in Access?" from yesterday
afternoon in this same news group.
 
T

Tolga Uzuner

Duane said:
You might want to look at the recent message with a subject of "How do i
convert yyyy_mm_dd strings to proper dates in Access?" from yesterday
afternoon in this same news group.
Click to expand...
Thanks Duane,
Tolga
 
Top