Get the first field selected

[#1]

I 've a field with dates (e.g. ACCOUNT_DATE).
If I select many dates, how to write the first account_date selected in a text object?

Thanks in advance.

[amars]

getfieldselections ( FieldName [, ValueSep [, MaxValues]] )

Returns a string with the current selections in a field.

ValueSep is the separator to be put between field values. The default is ', '. Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.

Examples

getfieldselections ( Year )

getfieldselections ( Year, '; ' )

getfieldselections ( Year, '; ' , 10 )

See if this help's.

You can get all the selections for the field & then using string function like Mid & FindOneof to retrieve the first token.

Regards

[Anonymous]

maybe something like min(ACCOUNT_DATE) ... to retrieve the lowest/first??