I am using  isdate function to verify  after extracting the first 8 chars from a sting.

isdate() returned 1 with the example below and my following code failed  to  calculated a Datediff().

Declare @Mystr varchar(29)
SET @Mystr=’05/020/2′
Select IsDate(’05/020/2′)

Is there any other similar function  in SQL?

Thanks in advance for any idea.

​I am using  isdate function to verify  after extracting the first 8 chars from a sting.isdate() returned 1 with the example below and my following code failed  to  calculated a Datediff().Declare @Mystr varchar(29)SET @Mystr=’05/020/2’Select IsDate(’05/020/2′) Is there any other similar function  in SQL?Thanks in advance for any idea.  Read More

​