Limiting a query using date

how should i format the conditional parameter on the WHERE clause to
limit the query on a date field.

Let say I want to limit the query from today up to a month back, or
today up to 20 days back.

Any ideas will be appreciated. Thank you.

re: Limiting a query using date

"Paul" <pcma10019@yahoo.com> wrote in message
news:78cbf985.0411020855.22ccf94d@posting.google.c om...[color=blue]
> how should i format the conditional parameter on the WHERE clause to
> limit the query on a date field.
>
> Let say I want to limit the query from today up to a month back, or
> today up to 20 days back.
>
> Any ideas will be appreciated. Thank you.[/color]


WHERE [Mdate]>=Date()-20
Fred Zuckerman