convert from text to date

D

dchristo

In a table I have a text field that contains a date "20070101"; in my query
is there a way to convert that from 20070101 to 01/01/2007 and make it a date
field.

Thanks
 
K

KARL DEWEY

Try this ---

DateSerial(Left([YourField],4),Right(Left([YourField],6),2),Right(Left([YourField],8),2))
 
Top