@datepart varchar(10) @datepart = '20130611'
IF ISDATE('20130611') = 1 PRINT 'VALID' ELSE PRINT 'INVALID'
DECLARE @myStringDates TABLE (myDate VARCHAR(30)) INSERT INTO @myStringDates (myDate) SELECT '20130618' AS myDate UNION ALL SELECT '18062013' UNION ALL SELECT '06182013' SELECT myDate FROM @myStringDates WHERE (CONVERT(INT, LEFT(myDate,4)) BETWEEN 1901 AND 2013) AND (CONVERT(INT, SUBSTRING(myDate,5,2)) BETWEEN 1 AND 12) AND (CONVERT(INT, SUBSTRING(myDate,7,2)) BETWEEN 1 AND 31)
20130618
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)