Date field

[kavarin]

I am trying to build a query that would filter record that have an quote expiration date between the current date and a date that the system prompts for. I want the system to automatically use the current date as the Start Date, and prompt for the exp date.

What I am trying to do is avoid getting EVERY record that expired prior to the prompted date, but rather a specific time frame

 

[Rich]

Between [EnterEndDate]And Date()in the criteria for expiry date

 

[kavarin]

Thank you Rich...
Works like a charm