text to date conversion

[Jason]

I have a very large table with about 15 "date" fields that were imported as text from a flatfile. I need to convert these fields to dates. The format that they are currently in are like this "12/31/99".

What is the easiest way to convert these fields to dates?

Thanks for any help
Jason Fitch

[mohan]

use convert function
eg: convert(datetime ,@text)

where @text your datefield

hope this solve your problem
by
mohan
------------
Jason at 12/13/00 11:26:49 AM


I have a very large table with about 15 "date" fields that were imported as text from a flatfile. I need to convert these fields to dates. The format that they are currently in are like this "12/31/99".

What is the easiest way to convert these fields to dates?

Thanks for any help
Jason Fitch