paste search string into date field

[rivet]

I have this search string in a global field:

'9/1/2002...9/1/2003'

I need to enter the find mode and set a date field to that string so it will find a range. Yet the script 'set field' enters it as '12/22/2497'

[Lee Smith]

Insert calculated result and text to date should do it.

Lee

[LiveOak]

To expound a little...

Insert Calculated Result[select,"MyDate", "DateToText(Date(9,1,2002)) & "..." & DateToText(Date(9,1,2003))"]

Make sure you are on a layout on which the field MyDate (or whatever your field is called) is diplayed.

-bd