Chris Good Posted January 27, 2005 Posted January 27, 2005 I have a problem where when I search using a date I get a "no records match this set of find requests" error. I am searching an invoice date field that is populated on creation and is indexed. In browse mode the date looks like 1/13/2005 and if I search in that exact same format it works fine. But if I type in 01/15/2005 it doesn't find the record. What is weird is I have another database that this works fine in. What am I missing? Thanks, Chris
-Queue- Posted January 27, 2005 Posted January 27, 2005 Are you sure the invoice date field is defined as a date and not text?
Chris Good Posted January 27, 2005 Author Posted January 27, 2005 I'm almost embarassed to reply to this. I had the field set to Text and not date. Thanks
Recommended Posts
This topic is 7580 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now