Script - paste search string into date field

[rivet]

I would like to paste search string ( "<01/01/02" ) into date field, but the calc string must result as a date and ends up as a question mark.

[RussBaker]

Its best to use either:

Insert Calculated Result [DateField,"<" & DateToText(Date)] if you have a date field, or

Insert Calculated Result [DateField,"<01/02/2002"] to hardcode the search criteria

BTW, you cannot ues SetField for this type of operation. SetField relies on the result being in the same format as the destination field. Insert Calculated Result doesn't worry about this.