How to select DueDate automatically?

[#1]

Hi Friends,

I Have a qvw which will get data from acccess database. The qvw contains table box. It is a straight values from access table. I used to send this report daily to user email.
The file will run based on DueDate. I select thei DueDate based on access backend data. i,e there is a backend report form and I used to open that report form and check the start and end dates of DueDate then after I select DueDate in table box.
I would need this to automate. i,e I don't want to open the access report form every time to see the DueDate. Is there any solution I can get this.

Here everytime the DueDate depends on three months dates.i,e for eg: the DueDate contains 01/03/2014 to 05/05/2014.

Can any one help me with script of how to write for DueDate?

All I need is the Date function script?

Thanks in advance.

[#2]

Any solution please?

[its_anandrjs]

Try to store the Due dates in any variables and then access that variable.

[sudeepkm]

Are you looking for having a Due Date range?

for example two date fields one for selecting start due date and another is for end due date and then based on which the data should be populated. Please clarify?

[#5]

Thanks. It is based on both start due date and end due date. My problem is every time I need to look in to the front end report form in access database to find the start due date and end due date. But I don't want to do this manually, instead I need it automatically to find due dates. Is it possible?

[sudeepkm]

Please take a look at the example created by Josh Good.

Selecting Arbitrary Date Ranges