Sleepless night over this one, Help me out Guys.
We have clients who have a fixed anniversary date. This date never changes but comes up for renewal every year and is stored in an anniversary table linked by the form. Every year we create a new record for the client, run through the processes and finish with a completed date which might be 4 weeks either side of the anniversary date. Example: Anniversary Date: 6th July 2007. Process completed date 17th July 2018. New Due date: 6th July 2019.
In our scenario we have some clients not updated for say 3 years or so with no records created for them in that time but the DateSerial reports next year as a due date. Example: last completed date: 9th July 2014. Due Date 6th July 2019.. HELP!!!
Completed Date fieled is in client table and anniversary date is in anniversary table.
We have clients who have a fixed anniversary date. This date never changes but comes up for renewal every year and is stored in an anniversary table linked by the form. Every year we create a new record for the client, run through the processes and finish with a completed date which might be 4 weeks either side of the anniversary date. Example: Anniversary Date: 6th July 2007. Process completed date 17th July 2018. New Due date: 6th July 2019.
In our scenario we have some clients not updated for say 3 years or so with no records created for them in that time but the DateSerial reports next year as a due date. Example: last completed date: 9th July 2014. Due Date 6th July 2019.. HELP!!!
Completed Date fieled is in client table and anniversary date is in anniversary table.