jcaptchaos2
Well-known Member
- Joined
- Sep 24, 2002
- Messages
- 1,032
- Office Version
- 365
- Platform
- Windows
Have a query where I'm asking the person to enter a date that will pull data from a table for the date requested, my problem is the data in the table is stored like this. "4/14/2011 4:44:40 PM" when you look in the table it is formatted as Short Date so it looks ok but for the query criteria to work the person would have to type in "4/14/2011 4:44:40 PM" and really all I want then to have to type is "4/14" What can I do to correct this?