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)
Run the script
FM Error: The provided find criteria is not valid. Enter a valid request before proceeding
Any help appreciate...