convert text column to date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
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.

John W. Vinson said:
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
Click to expand...

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]
Click to expand...
 
Back
Top