View Full Version : Date field


kavarin
05-24-2002, 08:53 AM
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
05-24-2002, 11:46 AM
Between [EnterEndDate]And Date()in the criteria for expiry date

kavarin
05-24-2002, 12:00 PM
Thank you Rich...
Works like a charm