Filter load on date

[#1]

Hi

I have the following script for one of my DIMS:

DIMFinancialPeriod:

SELECT date as FinancialPeriod

, [Year] as 'Year'

, [quarter] as 'Quarter'

, left([month],3) as 'Month'

,left([month],3) + ' ' +[Year] as 'MonthYear'

,[Year] + ' ' + left([month],3) as 'YearMonth'

FROM Dates

where date between '2013-04-01' and '2013-06-30'

Is it possible to pass a param into the where statements for the date which is not having to be alerted in the script when the QVW is reloaded? In addition could this be something that could be driven by like a admin screen?

Thanks

[tresesco]

Once you create ODBC/OLEDB connection you can use it directly as it is in qlikview like:

SQL Select <your command>;  qv will actually make it be executed by the connection string engine.

[#3]

sorry could you elaborate?