Jump to content
Sign in to follow this  

Searching by Date

Recommended Posts

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?

Share this post

Link to post
Share on other sites

Create A calculation:

Year(Modified date) Result Number

This should give you the 4 digit year.

You could search this field for "2001"

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.