FiveTech Support Forums

Is there a function that will tell us the data type for an index ?

I have a search function ( generic ). It receives a list of search titles, and the corresponding index names. It also has a box to enter a starting value, and then it performs a soft seek.

All works fine except dates. Dates are placed in the box as a string value but the index is in date order. I need to detect an index that is on a date field so I can add code to convert that type of string to a date equivalent for searching.

I can do it the "long way" but that takes a lot of extra coding in the program. So, if a function is available, that would be nice.

If not, then I can create a solution ..

Tim

TimStone wrote:Is there a function that will tell us the data type for an index ?

? VALTYPE( ORDKEYVAL() )

Thank you. That works perfectly.

Tim