Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Finding bad dates

Author  Topic 

otto
Starting Member

21 Posts

Posted - 2005-03-14 : 18:17:47
I have some DTS packages that I need to run against some large tables. What I'd like to do is find bad dates in a table prior to running my DTS package.

For the life of me I can't figure out how to do this. Perhaps I need more coffee or a break. Either way, I'm looking for help. :)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-14 : 18:18:47
ISDATE function should do the trick.

Tara
Go to Top of Page

otto
Starting Member

21 Posts

Posted - 2005-03-14 : 18:47:48
Thank you! Do you ever forget what are t-sql functions and what are functions in c#. I do.

+1 for you!
Go to Top of Page
   

- Advertisement -