Finding a date

[Mike-LI-NY]

I'm having trouble when searching for a date.

In FILE A, I have a date field and I type in "12/12/2003".

I push the button next to it and it activates a script in FILE B that searches for "12/12/2003" in the date field - however it keeps saying that no records match - even though there is! If I start in FILE B and search for 12/12/2003, then it works fine.... any ideas?

[John Caballero]

How is the data that you entered in File A getting transferred to the field in File B?

[Mike-LI-NY]

Hey John

After I type the date into the date field in File A, I push a button which runs a subscript in File B. That subscript sets the date field in File B to the date field in File A and then performs the search.

Any idea?

M

[BobWeaver]

Put a pause step in the File B subscript just before the perform find step so that you can see exactly what criteria has been entered.

Also, make sure that you have unchecked the "restore" option in both the Enter Find Mode step and the Perform Find step.