Extraer caracteres de una fecha

SQL = "SELECT ID,SUBSTRING(CAST(DATA AS NVARCHAR(11)), 9, 2) AS DIA,SUBSTRING(CAST(DATA AS NVARCHAR(11)), 6, 2) AS MES,SUBSTRING(CAST(DATA AS NVARCHAR(11)), 1, 4) AS ANNO  FROM  TABLA WHERE  DATA  >='" & FECHA1.Text & "' And DATA <='" & FECHA2.Text & "'"