I'm trying to increment a column based on the Admission date, there are some exams where each student should give for certain frequency, for ex if a student joined in 01/01/2015 and there is an exam called Personal Hygiene where he needs to write it every year and he needs to finish the exam after 5 days of exam assignment date where start date is first assignment date and the particular date in every following year is the next assignment date. so i need to find whether a student is pass for this year based on the above date. below is the practical problem for reference.
Student Name: Adam
Admission Date: 01/01/2015
Exams:
1.Personal Hygiene (this exam every student should write every year)
2.Insurance (this exam every student should write for every two years)
Days to complete the exam:
Personal Hygiene: 5 Days
Insurance: 30 Days
Date_Completed:
Personal Hygiene: 05/01/2018 (this exam is fail as he needs to write the exam every year and this years assignment date is 01/01/2019 so he needs to complete this by 05/01/2019 but he didnt even take the exam at all in this year so its a fail)
Insurance: 18/01/19 (this exam is pass because he'll get the exam assigned every two years and latest is 01/01/2019 and he needs to complete it in 30days, and he completed before that so its a pass).
In these cases, you will generally get better responses if you can attach some sample data in a spreadsheet etc. as well as your expected output in the QVW, that helps folks better offer up suggestions for things. If you can add that, I suspect you may get some responses at that point, but right now it is a bit confusing I think.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
