Bluezman
02-14-2002, 04:07 AM
Is it possible to find a projected date in the future for an event? For instance, I have a clubs membership records now totaling up their "time in service" using the following calculated field:
TOTAL1: DateDiff("d",([InitiatedDate]),(IIf([Suspended1Date] Is Null,(IIf([Demit1Date] Is Null,(IIf([DateOfDeath] Is Null,Date(),[DateOfDeath])),[Demit1Date])),[Suspended1Date])))/365.25
I also have a TOTAL2 and TOTAL3 field that take into account dates if reinstatement, and a final FINALTOTAL to sum them all together.
What I would also like to do is to project into the future and find the date a member will become a 25, 50 or 75 year member, and have this as a calculated field based on their in/out activity.
Any ideas on how to implement this ??
Bluez
TOTAL1: DateDiff("d",([InitiatedDate]),(IIf([Suspended1Date] Is Null,(IIf([Demit1Date] Is Null,(IIf([DateOfDeath] Is Null,Date(),[DateOfDeath])),[Demit1Date])),[Suspended1Date])))/365.25
I also have a TOTAL2 and TOTAL3 field that take into account dates if reinstatement, and a final FINALTOTAL to sum them all together.
What I would also like to do is to project into the future and find the date a member will become a 25, 50 or 75 year member, and have this as a calculated field based on their in/out activity.
Any ideas on how to implement this ??
Bluez