1 2 Previous Next 22 Replies Latest reply on Feb 22, 2014 11:46 PM by BruceRobertson

    Trouble creating a script step to find by date range

    RichardSmall

      I am trying to create a script to allow the user to enter a beginning date and an ending date, using the two inputs to find by date range (e.g. "begindate..enddate"). I can enter the data by hand (e.g. 1/1/2011..2/27/2012) and it finds the correct records every time. When I use a script step that looks identical a Perform Find returns 401 (no records found).

      my script construction is...

       

      Show Custom Dialogue (two fields for start and end dates)

      Enter Find Mode

      Set Field (Date) "start date field & ".." & end date field"

      Perform Find

      Date is defined as a date field

       

      I have turned on Script debugger and Data Viewer to watch the script step by step and evaluate each field as I step through it but can find no solution there. I have spent two days reading Help and forum entries but am unable to find why it does not work. Can anybody point me to the solution? Thanks.

      Richard

        1 2 Previous Next