Jump to content
Sign in to follow this  
fmforumr

Search Date Range

Recommended Posts

New to filemaker - creating a report to only show closed projects for whatever month a user wants to search on.

I currently have

Enter Find Mode

Set Field [PROJECTS::Closed_Date; Month (Get(CurrentDate))]

Perform Find[]

This only shows records for the current month. Is there a way that a user can enter a specific month instead of Get (CurrentDate)?

Share this post


Link to post
Share on other sites

Hi FM

Have the user enter the month they would like to see into a field and use that field in the set field script instead of the get(current date) command.

Lionel

Share this post


Link to post
Share on other sites

You can specify any range of dates to be found. However, you should probably automate this for your users.

Check out the example files HERE by searching for [color:blue]Date Range Finds, Also, there has been plenty of Threads on this subject in the [color:orange]Finding & Searching Topic Area, which is where I'm moving this Thread.

HTH

Lee

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.

Guest
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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    RajaHashir 
×
×
  • Create New...

Important Information

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