Test list to numeric for Min and Max functions

Question

I was able to get a list of values in a list using: GetFieldValues(GetRecords("{23.EX.'"&[Related Event]&"'}", ""), 3)

However, is there a way to get the MIN and MAX from the list if the result is 3;4;7;8;9;10;11;12 ?

------------------------------
ROBERT STEVENS
------------------------------

MarkShnierYou · Answer

One would hope that these additional functions like MIN MAX would be rolled out "soon", but no word yet. Until then the only solutions would be a brute force parsing of the returned string into its parts assuming that the expected set retuned was some manageable number of entries like say 20 or maybe up to 50. Post back if you need help with such a formula.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community