Min function not working

[john9210]

FM 11, Adv. I have a field for dates and I calculate the year for each date with the Year function. To determine the maximum and minimum years in the field I use the Max and Min functions on the year field. I store them both as globals. The Max function works, but the Min function does not. It returns the maximum value. Any suggestions.

[comment]

I don't understand this part:

To determine the maximum and minimum years in the field I use the Max and Min functions on the year field. I store them both as globals.

The Max and Min functions, like all aggregate functions, work over a relationship. If you are in the same table, you can use a summary field to get an aggregate value for the current found set. Not sure why you would need global fields in either setup.