Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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' );
Thanks a lot, it works very well.
Please mark the question as answered and correct