Date Between Query

[Tic3]

How can I write a query that will retrieve all records from my database
with a date between the 19th of the current month and the 20th of the
previous month?

Thanks for any help!

Tic3

 

[Tic3]

To clarify...this is in Microsoft Access XP

Thanks again.

Tic3

 

[Sunny]

dt1 = date
dt2 = datediff("M",-1,dt1+1)
use these two dates in your query.

 

[Douglas J. Steele]

Assuming you're building the query using the query builder GUI, in the
Criteria cell under your date field, type the following:

BETWEEN DateSerial(Year(Date), Month(Date) - 1, 20) AND
DateSerial(Year(Date), Month(Date), 19)

(Don't worry: the DateSerial function will handle it correctly in January,
when Month - 1 = 0)