Newbies fmforumr Posted September 18, 2007 Newbies Share Posted September 18, 2007 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)? Link to comment Share on other sites More sharing options...
The Big Bear Posted September 19, 2007 Share Posted September 19, 2007 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 Link to comment Share on other sites More sharing options...
jadenguy Posted November 30, 2007 Share Posted November 30, 2007 is there a way to have two months of search happen? or a date range? Link to comment Share on other sites More sharing options...
Lee Smith Posted November 30, 2007 Share Posted November 30, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5991 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