Failed to Test SQL Statement in Database Connection Point

lamis-alaa

I try to get the range between the first day and the last day of the year for SQL statement  in Database Connection point , i try the below query and get this error

EGACDT BETWEEN SELECT convert(varchar,DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0),112) as 'First Day of Current Year'
AND
SELECT convert(varchar,DATEADD(MILLISECOND,-3, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0)),112) as 'Last Day of Current Year'

i think the problem not only with the convert , it does not accept subquery !

Maxime Richard

Hello,

No SELECT ? 

BETWEEN convert(varchar,DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0),112) AND convert(varchar,DATEADD(MILLISECOND,-3, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0)),112)