C>DECLARE @BeginDate datetime, @EndDate datetime

C>SET @BeginDate = CONVERT(datetime,'10.07.2005',104)
C>--SET @EndDate = '2005-30-07'

C>EXECUTE ('SELECT *
C>        FROM Table
C>        WHERE (CrtDate BETWEEN '+@BeginDate+'AND '+@EndDate+')')
C>

C>SET @BeginDate = CONVERT(datetime,'10.07.2005',104)
C>