View Full Version : User-entered dates within Queries


Christine Fenson
04-25-2000, 11:54 AM
Is there any way to allow the user to enter only month and date without the year when a user is prompted for a date?

This worked fine before the year changed to 2000 and if the user does not enter "2000" with the date, a "No records found" message appears, which can be very misleading.

If this is not possible, what about a message which suggests to the user to re-enter the date including the year?

Melvin Davidson
04-26-2000, 12:57 PM

I suggest you try downloading Cal Locklin's Y2K scripts
which you can find at


Please give Cal the courtesy of dropping him a note if
you find them useful-> calocklin@aol.com