maxdate function

[The Big Bear]

Hi all

I have two questions.

I am trying to find the last date a welder has welded in one process using the "max" function. I am not understanding something about the "max" funxtion because i cannot get it to work properly. I can det the "min" function to work.

The second question is it possible to find the last date a welder has welded in more than one process using the "max" function.

Example:

last day welder welded using the GTAW process

Last day welder welded using the FCAW process

Can this be shown at the same time on the same screen.

I hav attached a file showing that i want to do

maxdate.zip

[bruceR]

You might want to look at your own file and observe the difference between how you are using max and min. In any case, you have to think about max (or min) compared to what? You have to tell FileMaker which records you want compared.

In the case of the min function you are doing exactly that - you are using a relationship and saying what is the min of all these related records? Min(gtaw_manual::date)

In the case of the max function you are NOT using a relationship and you are just passing a single date. Max(Date)

Obviously you need to do the same thing you did with min:

Max(gtaw_manual::date)

[The Big Bear]

Thanks

Could not see the trees for the forrest