Convert date serial from text to date value

[Guest]

Field is text, value is "39254".

I want to sort and format as short date.

Cdate and Cvdate seems to be looking for short date format in text i.e
"01/01/01"

I tried to just redefine the field from text to date, but that deletes
records.

How to I convert to date serial from text that looks like date serial, not
date.?

Thanks

 

[Douglas J. Steele]

Add a new Date field and do an Update to populate it:

UPDATE MyTable
SET DateField = CLng([TextDateField])

 

[SusanV]

Hi Lee,
Is this a one-time thing? I couldn't find anything for Access, but you
could do it in Excel:
http://www.codeproject.com/datetime/exceldmy.asp

 

[Guest]

Thanks Doug,

Should this not work in a Query, as well?

DateField: =Clng(TextDateField)

Add a new Date field and do an Update to populate it:

UPDATE MyTable
SET DateField = CLng([TextDateField])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Field is text, value is "39254".

I want to sort and format as short date.

Cdate and Cvdate seems to be looking for short date format in text i.e
"01/01/01"

I tried to just redefine the field from text to date, but that deletes
records.

How to I convert to date serial from text that looks like date serial, not
date.?

Thanks

 

[Douglas J. Steele]

Yes, but I thought you wanted a permanent solution.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks Doug,

Should this not work in a Query, as well?

DateField: =Clng(TextDateField)

Add a new Date field and do an Update to populate it:

UPDATE MyTable
SET DateField = CLng([TextDateField])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Field is text, value is "39254".

I want to sort and format as short date.

Cdate and Cvdate seems to be looking for short date format in text i.e
"01/01/01"

I tried to just redefine the field from text to date, but that deletes
records.

How to I convert to date serial from text that looks like date serial,
not
date.?

Thanks