# FieldRef.GetRangeMax() Method
> Version: _Available or changed with runtime version 1.0._
Gets the maximum value in a range for a field.
## Syntax
```al
Value :=   FieldRef.GetRangeMax()
```
> NOTE
> This method can be invoked using property access syntax.
## Parameters
FieldRef
Type: fieldref-data-type
An instance of the fieldref-data-type data type.
## Return Value
Value
Type: ../any/any-data-type
## Remarks
This method is like the ../record/record-getrangemax-method method.
## Example
The following example opens the Customer table as RecordRef variable, creates a FieldRef for the first field \(No.\) and stores the reference in the MyFieldRef variable. The fieldref-setfilter-method sets a filter that selects records in the range 10000 to 40000 from the No. field. The GetRangeMax method retrieves and stores the maximum value that was set in the filter, stores the value in the varMax variable and displays it in a message box. The varMax variable contains 40000 which is the maximum value that is set in the filter.
```al
var
    MyFieldRef: FieldRef;
    CustomerRecref: RecordRef;
    varMax: Text;
    Text000: Label 'The maximum value in the filter is %1.';
begin
    CustomerRecref.Open(Database::Customer);
    MyFieldRef := CustomerRecref.Field(1);
    MyFieldRef.SetFilter('10000..40000');
    varMax := MyFieldRef.GetRangeMax();
    Message(Text000, varMax);
end;
```
## Related information
fieldref-data-type
Get Started with AL<../../devenv-get-started>
Developing Extensions<../../devenv-dev-overview>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/fieldref/fieldref-getrangemax-method, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/methods-auto/fieldref/fieldref-getrangemax-method/
