DECLARE @FilePath varchar(250)
DECLARE @FileName varchar(250)
DECLARE @Year varchar(4)
DECLARE @FileDate varchar(10)
SET @FilePath = 'c:\FilePath\'
SET @FileName = 'FileName.Ext'
SET @Cmd = 'dir ' + @FilePath + @FileName
INSERT INTO #FileDate EXEC master.dbo.xp_cmdshell @Cmd
SELECT @Year = RIGHT(LEFT(field1 ,10),4) from #FileDate WHERE field1 like '%FileName.Ext%'
SELECT @FileDate = LEFT(field1 ,10) from #FileDate WHERE field1 like '%FileName.Ext%'