August 26, 201114 yr 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.
August 26, 201114 yr 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.
Create an account or sign in to comment