Jump to content

Date Calculation (Easy One)


This topic is 6077 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

"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

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

"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 by Guest
Link to comment
Share on other sites

This topic is 6077 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.