AnsweredAssumed Answered

How do I find records by entering date thru pop-up calendar into two date fields - Start Date and End Date?

Question asked by jayankurian on Oct 21, 2014
Latest reply on Oct 22, 2014 by jayankurian

Hi All,

A simple one for you, but not simple for me...


My users are not happy to search records in the DB using the filemaker built in date range search (9/1/2014...9/21/2014) feature.

What they want is enter the desired date range into two different fields(Start Date and End Date) using the pop-up calendar and press the continue button to find records.


I created two global fields Start Date and End Date and another concatinated calculation field DateCon (StartDate &"..."&End Date).


Created a script as below.


Enter find mode

Set field[Date:::DateCon] (date is my real Date field to be searched)

Perform find


Run the script

FM Error: The provided find criteria is not valid. Enter a valid request before proceeding


Any help appreciate...


Thank you