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?

    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