Query dates

[gheyman]

I have a date field (PDIR Completed). I would like to have a form that shows a query. But I want that query to based off a selection from a pulldown on my form (example of list: Last 7 Days, Last 14 Days, Last 30 Day and Last 60 Days)

If I select "Last 7 Days" I want the query (and therefore the Form) to only show the records where the PDIR Completed date was in the last seven days from today.

Any suggestions?

 

[AtlantaAccessAndExcel]

You will want to use the DateDiff function to figure out your date to query against DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear]).

You will need to use VBA code to determine your date, then apply a filter. You can also save the target date on a hidden field on your form, then use that hidden field as a criteria in your query. In this approach, you will need the Me.Requery statement to refresh the query.

I hope that gets you started. Post back if you need more help...

 

[welshgasman]

I would have said you would just need ">= date() - NumberOfDays"

How you decide the number is up to you.?
The combo could have

Field1   Field2
7          Last 7 Days
14        Last 14 Days
30        Last 30 days
60        Last 60 days

then just use the first element of the row selected

">= date() - " & Me.cboDays & " ORDER BY YourDate"