Basically you have to create

an appropriate string to use with Datevalue

This query displays the date

SELECT Table4.importdate, DateValue(Mid([importdate],2,2) & '/' & Right([importdate],2) & '/' & Left([importdate],2)) AS dates
FROM Table4;


This query

Updates the table

UPDATE Table4 

SET Table4.[date] = DateValue(Mid([importdate],2,2) & '/' & Right([importdate],2) & '/' & Left([importdate],2));



 

  

  Paul Manega <pmanega@q...> wrote: 
Hi everyone there:

I am working in Access and trying to update a blank Date
field using values from another Date field in the same
table. The Blank field is of Date/Time data type Format
mm/dd/yy hh:mm:ss. The Date field with the data is of Text
data type format “yymmdd”. Now, for every record, I want to
update the Blank field with the date from the Date value
from the Text Date field (minus one Day).

The Table looks like this:

ID ImportDate field3
field4 Date
0 null value
value 010418
0 null value
value 010520

What I want is to get the table to look like this:

ID ImportDate f ield3
field4 Date
0 04/17/01 12:00:00 value
value 010418
0 05/19/01 12:00:00 value
value 010520



Someone help with ways to go about it. Thanks in advance.

Paul Manega