convert text column to date.

[Guest]

Hello all,
I have a column on a table with the following text data:
Feb 24
Mar 7
Apr 3
....
etc
I want to create a query to read this column an write it to a date column in
the format dd/mm/yyyy
Any suggestion?
Thank you in advance

 

[John W. Vinson]

On Wed, 19 Sep 2007 16:02:03 -0700, Miguel Alvarez <Miguel

Hello all,
I have a column on a table with the following text data:
Feb 24
Mar 7
Apr 3
...
etc
I want to create a query to read this column an write it to a date column in
the format dd/mm/yyyy
Any suggestion?
Thank you in advance

If you don't mind having it fill in the current year, just

CDate([textcolumn])

will work in an update query.

How can you tell whether Dec 13 is Dec 13 2006 or Dec 13 2007? or 1994 or 2021
for that matter?

John W. Vinson [MVP]

 

[Guest]

That is exactly what I´m looking for. At this moment I don´t mind what year
is. This query is to check what users not accesed in a year. Therefore if I
see a login date like 1 oct 2007, this is wrong due to we haven´t reach that
date, then this login belongs to a previous year.

Thank you very much John.

On Wed, 19 Sep 2007 16:02:03 -0700, Miguel Alvarez <Miguel

Hello all,
I have a column on a table with the following text data:
Feb 24
Mar 7
Apr 3
...
etc
I want to create a query to read this column an write it to a date column in
the format dd/mm/yyyy
Any suggestion?
Thank you in advance

If you don't mind having it fill in the current year, just

CDate([textcolumn])

will work in an update query.

How can you tell whether Dec 13 is Dec 13 2006 or Dec 13 2007? or 1994 or 2021
for that matter?

John W. Vinson [MVP]