Is it possible to select variable values automatically?

[#1]

Hi,

I have qvw with macro which will send data to user email automatically. All is fine. The qvw contains two variables

VStartDate and vEndDate.

The data used to send every Monday before 12pm to user email. The completed week data will send. I,e Suppose today is Monday. so, the variables VStartDate and vEndDate contains

VStartDate=21/04/2014 and vEndDate= 25/04/2014. Like this I will manually selecting variables values every week.

My question is, Is there any solution that variables set automatic. I,e without my interference the variable should take before weeks dates. why I am asking is I don't want to miss the data any case in my absence.

Can anyone please suggest me this?

Thanks.

[#2]

you should schedule it in the task schedule maybe 5 to 10 minutes after you open the qvw

[#3]

let me know if it worked.

regards,

MT

[#4]

Thanks Magdalena Perfect it's working. !!!

EDIT: I really mean it

[#5]

Thanks to all !!