I need to track member status to determine seniority based on time (days) spent at a certain member status. I have a data type (Member Status) collecting Status and Effective Date for each member. This information is to be displayed in a repeating group in each members details page.
In the RG I would like each record to display the number of days the member has spent in the respective Status, this would be called Duration. It would require the Effective Date of the very first record created for a member to be subtracted from the Current Date/Time. Once a second record is created, the Duration of the very first record would need to then be subtracted from the most recently created Effective Date instead of Current Date/Time, and the most recently created records Effective Date would need to be subtracted from Current Date/Time.
This would continue as more records are entered to update a members status.
I have spent hours trying to figure this out, and I’m not even sure its possible at this point. Any help or suggestions would be greatly appreciated.
Don’t I get your point quite right but I know the bottom line is that u’re trying to get duration in days right?
If that’s right, you can as well create another entry to record the duration or a text element in the RG calculating the difference between the later date and the initial date in DAYS, something like; current date/time - current cell's effective date formatted as days
just reference the right data and do the math, you get the drill!
