Date Calculation (Easy One)

[Mickdn]

Please how do I get this calculation to look at the last entered date and not the first? It's just a list of dates that people have attended and all I want it to show is the amount of days since last attended.

Get ( CurrentDate ) - Attendance_Date

Many Thanks

[Vaughan]

"It's just a list of dates..."

You mean that all of the dates are entered into one field? If so, then that's the problem. Databases don't work that way.

The dates all need to be entered into records of their own. Then it's easy to find the record with the last entered date.

We need additional information to suggest anything more specific.

[Mickdn]

Sorry for the slow response Vaughan. If you take a look at the attached file it should show what I'm after. Mick

DoJo.zip

[Vaughan]

The Last Attended calculation needs to be in the Details table, not the related table. The calc should be:

Get( CurrentDate ) - Max( Attendance::Attendance Date )

[Mickdn]

New it was an easy one (for experts), never even new the Max function existed, still learning, is Filemaker great!

Thanks Again!!

[Vaughan]

"ever even new the Max function existed..."

Yep, there are lost of functions to play with.

Another thing you need to know: say a Details record has more than one related Attendance records. From the Details (parent) record, a reference to a related Attendance field will only return the value from the *first* related record. The Max() function is able to see all the related values, as can the Sum(), Count(), List() and some other functions.

Edited October 31, 2007 by Guest