SQL Query Date Parameters

Looker Q&A Looker Studio
,
1

Hello,

I need some help please, to find the correct query from Looker zu Azure SQL

I have been reading this article but it did not work: https://support.google.com/looker-studio/answer/10588439

If I use this query it will work:

SELECT * FROM angebote WHERE Datum >= ‘2014-01-06’ AND Datum <= ‘2014-01-10’

The parameters (Von_parameter and Bis_parameter) I have set are formatted as text, example: 06.01.2014

This Query wont work:

SELECT * FROM angebote WHERE Datum >= CONVERT(DATE, @Von _parameter, 104) AND Datum <= CONVERT(DATE, @Bis_parameter, 104);

Could you please tell me, what I have to do?

Thank you!