Newbie with UPDATE question

[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

 

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

 

[Tolga Uzuner]

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.

Thanks Duane,
Tolga