tag:blogger.com,1999:blog-5655646.post112733094615003675..comments2011-09-13T09:18:09.956-05:00Oskarhttp://www.blogger.com/profile/02957780889508741710noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5655646.post-1144077323936612962006-04-03T10:15:00.000-05:002006-04-03T10:15:00.000-05:00Mounir, thanks.<BR/><BR/>My original code was quite brain-dead - after my struggles with ISNUMERIC I had been fixating on dates that contained year-info only.<BR/><BR/>The corrected function can be found <A HREF="http://austegard.blogspot.com/2006/04/sql-corrected-issmalldate-function.html" REL="nofollow">here</A> and also on <A HREF="http://www.bigbold.com/snippets/posts/show/1180" REL="nofollow">Code Snippets</A>.<BR/><BR/>Thanks again for correcting my bug.Oskarhttp://www.blogger.com/profile/02957780889508741710noreply@blogger.comtag:blogger.com,1999:blog-5655646.post-1144055155067330512006-04-03T04:05:00.000-05:002006-04-03T04:05:00.000-05:00this script will not work correct! because, it execute correctly this datetime (exp. 01.01.1888). but, this exemple is not the smalldatetime !! <BR/>i want correct them, i modified this script on follow :<BR/><BR/>--Checks if a string is a valid smalldatetime<BR/>ALTER FUNCTION dbo.IsSmallDate<BR/>(<BR/> @SmallDateString varchar(20) --The input string to check<BR/>)<BR/>RETURNS BIT<BR/>AS<BR/>BEGIN<BR/> DECLARE @Result bit<BR/> SET @SmallDateString = LTRIM(RTRIM(@SmallDateString))<BR/><BR/> if (isdate(@SmallDateString)=1 and (year(convert(datetime, @SmallDateString)) between 1900 and 2079))<BR/> SET @Result = 1<BR/> ELSE<BR/> SET @Result = 0<BR/> END<BR/> RETURN @Result<BR/>ENDMounir BEN HAMEDnoreply@blogger.com