Conversion in Query

M

Michael Feldman

I am looking to convert a Text String of 9/10/05 in a field Misc.Value1 to a
date field.
 
D

Douglas J. Steele

Assuming that represents 10 Sept, 2005, you should be able to simply use
CDate(Misc.Value1).

If it represents 09 Oct, 2005, you'll have to split it into the separate
Day, Month and Year components (using the Left, Mid and Right functions),
then plug them into the DateSerial function.
 
Top