Date value, convert from text to date type

  • Thread starter Thread starter Serg
  • Start date Start date
S

Serg

Hi people,

how to convert this value that was originaly imported as
text data type to date data type like this, example:
Original value as text
Saturday, March 20, 2004 11:02:01 AM
Need this
03/20/2004
Thanks a million,
Serg
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You'll have to get rid of the day name. Something like this:

cdate(mid$(date_column,instr(1,date_column, ", ")+2))

This formula will get rid of the day name & convert the date_column to
an Access date/time data type.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQTZVpYechKqOuFEgEQKQ+ACffKgULb4L2skkv3UrHwRNxgE8rwgAniB5
Pbe3Z9dQGBWxLF3y9hQWJmZ+
=oKCY
-----END PGP SIGNATURE-----
 
You will have to strip off the day name and then you can use datevalue.
Something like the following UNTESTED expression

DateValue(Mid([DateString],InStr(1,[DateString],",")+1))
 
Thank you people,
it works excellent!!!
-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You'll have to get rid of the day name. Something like this:

cdate(mid$(date_column,instr(1,date_column, ", ")+2))

This formula will get rid of the day name & convert the date_column to
an Access date/time data type.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQTZVpYechKqOuFEgEQKQ+ACffKgULb4L2skkv3UrHwRNxgE8rw gAniB5
Pbe3Z9dQGBWxLF3y9hQWJmZ+
=oKCY
-----END PGP SIGNATURE-----



.
Click to expand...
 
Back
Top