>Hi All,
>
>Can anyone help me with the conversion of '20041223' string to datetime data type in the following format 12/31/2004 ?
>
>TIA,
>Daniel M.
Hi Daniel,
T-SQL:
convert(datetime, '20041223', 110)
Magnus NordinVFP MCP
"We have tested the GUI on 5-year olds. Why? Beacuse they aren't braindead!"
Michael Spindler, Apple