Convert date

[Jason Morin]

I have a text field in a table that are dates such as
2003-09-11. How can I convert this field to the actual,
usable date? In Excel I can multiply by 1.
TIA.
Jason

 

[Rick Brandt]

I have a text field in a table that are dates such as
2003-09-11. How can I convert this field to the actual,
usable date? In Excel I can multiply by 1.

CDate([FieldName])