Hi,

Would anyone know how to capture find criteria for a Number or Date type field when >, <, <>, etc. operators are used.

My users want to see search criteria before they perform a search, and want to be able to print them for future references.

I created a gSearchCriteria global field, which is populated by a script which is looping through all filelds on a layout (they are in a FIND mode). If Status(CurrentFieldContent) is not empty, it appends Status(CurrentFieldName)

and Status(CurrentFieldContents) to a gSearchCriteria global field.

It works fine except when the Field Type is Date or Number, and they enter ">", "<", or other other logical operators. In this case CurrentFieldName is captured, but it appears that CurrentFieldContents

is empty. I tried Set Field, Insert Calculated Results, Copy / Paste from the current field to the Search Criteria global.

Is there a way to capture the data?

Thanks

Short answer: you need to use copy and paste to get this info rather than using a set field command.

Long answer: See this topic in the samples forum

http://www.fmforums.com/threads/showflat.php?Cat=&Board=files&Number=64550&page=0&view=collapsed&sb=5&o=31&fpart=1

I was able to reproduce what you mention ... interesting, I had never noticed it ...

Probably you could pull it off using a text field in which users enter the date but this would be cludgy to say the least and would also open the problem of validating entered criteria ...

See if this tip file can be of help:

http://www.buliga.it/TipFiles/SFISearch.sit

http://www.buliga.it/TipFiles/SFISearch.zip