Min(), Max(), First(), Last() are all useful functions that seem similar, but have different uses depending on the needs of the variable/formula
Min and Max
Min() and Max() will show the highest or lowest value of the object in question, but that value is determined by the object type
Text objects will be organized alphabetically
Number objects will be organized numerically
Date objects will be organized by date
First and Last
First() and Last() will use the context of the table it is present in to try to determine which is the first or last value. It also knows the difference between text numbers, and dates, but may try to define that based on other objects in the table.
Example
If there is an attendance object with a Yes or No value, Max([Attendance Object]) will always return a Yes, but Last([Attendance Object]) will try to find the most recent value. It will try and use a relevant date taken object to determine the most recent value, but it may not find the most recent value accurately if the date taken object is not present in the table Last([Attendance Object]) is being used in.
Related Articles