question using the function Max

[The Big Bear]

Hi all

I have a record id field that is formatted as text. The information that is in this field is a combination of numbers and text.

Example 3700 FCAW -s 773211

The last number is a date converted to numbers

I am trying to find the maximum record ID using the Max function. But only that is displayed is the numbers

Example: 3700773211

I will assume that the Max function in this case cannot displayed text and number together and is there a other function to achive what I would like to do.

Thanks

Lionel

[Raybaudi]

Hi

If we have these IDs:

1500 ABCD -z 773211

1000 EFGH -a 773211

0001 ILMN -u 773211

which one must be the Max for you and why ?

[The Big Bear]

Daniele

There will never have ID's as you noted below.

1500 ABCD -z 773211

1000 EFGH -a 773211

0001 ILMN -u 773211

The record ID is created for a Welder program that we use at work. A new Record is created every couple months for each welding process that a welder is qualified to use.

so the record ID maybe as follows

3700 FCAW -s 771132

3700 FCAW -s 771248

3700 FCAW -s 771367

using the max function which is formatted as a text field will display

3700771367

Thanks

Lionel

[comment]

I think the easiest solution would be to adhere to the "one fact per field" rule and split the data into two (or more?) fields.

[RalphL]

Have you considered using the Max function with the RightWord function?

[The Big Bear]

thanks for the information. Will do that but is this what the Max function is suppose to display when the field contains numbers and text?

Thanks

Lionel

Edited January 6, 2009 by Guest

[comment]

is this what the Max function is suppose to display when the field contains numbers and text?

Yes - see:

http://fmforums.com/forum/showtopic.php?tid/193363/

[The Big Bear]

thanks