Newbies owlice Posted May 1, 2001 Newbies Share Posted May 1, 2001 Boy do I feel stupid -- I've worked with Filemaker a few months now, but cannot do this simple task. I've searched my FM bible and the Help Index to no avail. If I want to search for records by Date -- such as Date Last Modified -- and for example, just want to isolate the records for 2001 by performing a Find using "2001" -- I get a message, "Must be entered in x/y/zz format" and it cancels the Find. I've tried using a DateToText field to do a similar numerical search but it says "No Records Found." Does my date field need to be formatted in a special way for me to be able to search by Date? Link to comment Share on other sites More sharing options...
dspires Posted May 1, 2001 Share Posted May 1, 2001 Use this: 1/1/2001...12/31/2001 or (until next year): 1/1/2001... Link to comment Share on other sites More sharing options...
Ocean West Posted May 1, 2001 Share Posted May 1, 2001 Create A calculation: Year(Modified date) Result Number This should give you the 4 digit year. You could search this field for "2001" Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8395 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