7 Replies Latest reply on Oct 22, 2014 4:55 AM by jayankurian

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


      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