Converting a text line to a date

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

Guest

Hello,
I have a question about converting a text line of data (20060317162609) to
the correct date format. The date format will need to be 03/17/2006. I have
tried several different ideas from this group but nothing has worked. I don't
know if I'm putting the string in the correct place. I would like to see it
convert it during the query but I have had no luck. If anyone could help me
out with the code and where to place it that would be great!!

Thanks

Geoff
 
geoff said:
Hello,
I have a question about converting a text line of data
(20060317162609) to the correct date format. The date format will
need to be 03/17/2006. I have tried several different ideas from this
group but nothing has worked. I don't know if I'm putting the string
in the correct place. I would like to see it convert it during the
query but I have had no luck. If anyone could help me out with the
code and where to place it that would be great!!

Thanks

Geoff
Click to expand...

Is the data 100% consistent?
What error are you getting?
 
Back
Top