Mickdn Posted October 30, 2007 Share Posted October 30, 2007 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 Link to comment Share on other sites More sharing options...
Vaughan Posted October 30, 2007 Share Posted October 30, 2007 "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. Link to comment Share on other sites More sharing options...
Mickdn Posted October 31, 2007 Author Share Posted October 31, 2007 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 Link to comment Share on other sites More sharing options...
Vaughan Posted October 31, 2007 Share Posted October 31, 2007 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 ) Link to comment Share on other sites More sharing options...
Mickdn Posted October 31, 2007 Author Share Posted October 31, 2007 New it was an easy one (for experts), never even new the Max function existed, still learning, is Filemaker great! Thanks Again!! Link to comment Share on other sites More sharing options...
Vaughan Posted October 31, 2007 Share Posted October 31, 2007 (edited) "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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6113 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now