Formatting text to Date

[bonngo]

My problem is I have data imported in from an xml feed which is formatted for ex. 20060118T103737

I need to convert this into a mm/dd/yyyy format and drop off the data from the "T" over to the right which is the time of the posting.

Thanks for any help!

[Raybaudi]

Date(Middle(xml;5;2);Middle(xml;7;2);Middle(xml;1;4))

[bonngo]

Thank you so much!!