AnsweredAssumed Answered

Turning two date fields into one search criteria.

Question asked by halsted on Jun 25, 2012
Latest reply on Jun 25, 2012 by halsted

Hi hope somebody can help, a rather unskilled filemaker guy.


I’m a user of Filemaker and have been for more than 10 years.

A mainly use FM for looking up business related information and for making rapports.

I do not have any programming experience, but I’m rather curious.


Hope somebody here can help me out with a problem I have been struggling with.


I’m managing a sales organization, and want to publish our sales, to my local Account managers in a filemaker go Ipad database. Non of our AM have any experience with FM, so a fairly simple layout, mainly based on buttons will be necessary.


What I want is, hit a button that takes you to a search layout.

On that layout I want two date fields with calendar popup, so the salesman can press two dates that will bee turned in to the search criteria eg. 01-01-201231-12-2012 that can be used in find mode to search for sales in a specific period.


I have been thinking ‘’global fields’’ but I can figure out how to make a script that can copy the two date from the two data fields and turn it into a search criteria. Please help.