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

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 ?

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

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.

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

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, 200917 yr by Guest

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/

thanks