Converting Text Date to true Date format

[Anthony C]

Hi All,

I have a text field with a date that I'm attempting to convert to a true
date--the values look like this: "11/01/04" . I have attempted to use
right/left functions encased in CInt functions to change the text to numeric
values to no avail. Does anyone know a quick & easy way to convert this
text into a date? It needs to be forced into a date field in another table.

Thanks in advance!
-Anthony

 

[Rick Brandt]

Hi All,

I have a text field with a date that I'm attempting to convert to a true
date--the values look like this: "11/01/04" . I have attempted to use
right/left functions encased in CInt functions to change the text to numeric
values to no avail. Does anyone know a quick & easy way to convert this text
into a date? It needs to be forced into a date field in another table.

If that date represents November 11, 2004 then you should be able to just put it
into the Date field and Access will automatically coerce it into a date value.
Access assumes US date format and as long as the text expression CAN be
converted to a date then Access will do so.