Dates in a list box

[UT227]

I'm trying to show information in a list box, but only dates that are up to 10 days prior to the current date. This is the SQL I wrote: SELECT [LeaveDatesID], [LeaveRequestID], [LeaveDate], [WorkLeave], [LeaveHours] FROM qrySchLeaveDates2 WHERE <Date() And >=Date()-10 ORDER BY [LeaveDate];
I got this error:

[ranman256]

Use date math functions:
between dateAdd("d",-10,Date()) and Date()

[UT227]

Thanks. That worked great. That's a new one for me. I appreciate the help.

[pbaldy]

As a learning FYI, your error was because there was no field specified:

WHERE <Date() And >=Date()-10

It needed to be more like:

WHERE LeaveDate < Date() And LeaveDate >= Date()-10

Using the function is fine though.

[UT227]

I thought I might have been forgetting to put something in that. Thanks.

[pbaldy]

No problem.