select data only from the last 30 days

[Anonymous]

Dear all

I like to select data only from the last 30 days. It works static, but I like to have this dynamic.

Thanks for your help in advance.

[petter]

Be aware that everything between the SELECT and the following semicolon is interpreted by the SQL source/database. So any logic used in the Where part of the statement would follow the syntax and functions available in the SQL data source.

But you should be able to use $-sign expansion that will be executed before the load script sends the SQL SELECT statement to the source. Maybe like this:

v30DaysAgo = Date( Today(1)-30 , 'YYYYMMDD' );

Select * From ABCD Where abcd >= '$(v30DaysAgo)';

[Anonymous]

Thanks a lot, it works very well.

[petter]

Please mark the question as answered and correct