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)?

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

is there a way to have two months of search happen? or a date range?

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