"magendo_man" wrote:

> The SQL should read something like:
>
> SELECT *
> FROM MyTable
> WHERE MyDateField BETWEEN GETDATE() AND DATEADD(Day, 14, GETDATE())
>
> HTH,
> Magendo_man
>
> "Samson" wrote:
>
> > How would I make a query that checks for all dates using a feature that
> > automatically selects todays date and then 14 days in the future. Meaning
> > all records between today and 14 days in the future.
> >