>
We've got a data file that has dates in 'dd-mm-yyyy (time)' format (and coming in as a string) and need them in 'standard amurican' 'mm-dd-yyyy (time)'.
>
>What's the best way to do this conversion?>
>Have you tried using the CAST() function?
Cast just has issues, Convert says "Conversion failed when converting date and/or time from character string
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place