Schedule data pull from DB

[knight_rider2905]

I'm pulling data from db of last week every Monday, having start and end date in query. I want to schedule this activity so that manual intervention is not needed for pulling data.

I want to understand how we can use current date function to schedule this job or is there any other way to schedule this activity.

[denisb]

You can use today() as Date in your SQL .

For example: 

LET currentDate = today();

SQL select * from myTable where date >= $(currentDate) - 7 days;

You can also use your current date from SQL Server and just schedule the Qlik Sense Task on every monday.