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"
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.