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

Attachments

Outcomes