04_dateformat.sql

DECLARE @date1 NVARCHAR(20) = '10.01.2022';

-- Set the date format and check if the variable is a date
SET DATEFORMAT mdy;
--PRINT @date1;
SELECT ISDATE(@date1) AS result
	, @date1 AS review_date;
GO

-- By using the GO keyword we have segmented the code and now the interpreter does not know 
-- what the local variable @date1 is
SELECT ISDATE(@date1) AS result
	, @date1 AS review_date;