Date Problem

[Guest]

I have a table with two TEXT fields : Date1, Time
emample of data is ate: 140406 , Time: 0601p
I want to convert this to DATE format as follows : 060414 : 0601PM
I am using the following in the querry:
TransDtTm:
DateSerial(Right([Date1],2),Mid([Date1],3,2),Left([Date1],2))+TimeSerial(Left([Time],2),Mid([Time],3,2),right([Time],1)

Why is it not working? The date part if done by its own , does work, but the
time part does not...
Could you help , please

 

[Guest]

I bet that you just had the data in one real Date/Time field now....

First of all I'd worry about the + sign as it could do math on the results
which would cause problems. Try the & ampersand instead.

Second instead of using DateSerial and TimeSerial, just format the data to
look like you want it to UNLESS you actually need it to be a Date datatype.

 

[Guest]

Jerry, thanks for the reply...

Yes, I want it to be in date fromat :yymmdd :hhmm AMPM
I tried th & and it does not give the result I need.
Bootom line : I need to convert the two text fields that I import to the
baove format by combining them.
Thanks

I bet that you just had the data in one real Date/Time field now....

First of all I'd worry about the + sign as it could do math on the results
which would cause problems. Try the & ampersand instead.

Second instead of using DateSerial and TimeSerial, just format the data to
look like you want it to UNLESS you actually need it to be a Date datatype.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have a table with two TEXT fields : Date1, Time
emample of data is ate: 140406 , Time: 0601p
I want to convert this to DATE format as follows : 060414 : 0601PM
I am using the following in the querry:
TransDtTm:
DateSerial(Right([Date1],2),Mid([Date1],3,2),Left([Date1],2))+TimeSerial(Left([Time],2),Mid([Time],3,2),right([Time],1)

Why is it not working? The date part if done by its own , does work, but the
time part does not...
Could you help , please