AnsweredAssumed Answered

Trouble creating a script step to find by date range

Question asked by RichardSmall on Jul 12, 2012
Latest reply on Feb 22, 2014 by BruceRobertson

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

Outcomes