Between Date Parameter

[FlyBoy]

Asked a similar question earlier, but guess I was all over the board with it.

I'm trying to use the DRW to query an Access database to return results for
events happening between dates. Is this possible?

Thanks

 

[Tom]

select * from database
where datefield between '::FormDateStart::' and '::FormDateEnd::'

This is assuming the user is supply the start and end date in a form. The
form is sent to an ASP page where you create the above "Custom Query".
Naturally, replace the fieldnames (datefield, formDatestart, FormDateEnd)
with your names...

To show something more dynamic without user input (user input would require
validation of a valid date format), something more like a link for say, the
next 30 days would be like this:

select * from database
where datefield between today() and today()+30