Good day!
I have a table in which the attendance points for each employee is tracked and on which date that attendance point was incurred. I now need a way to calculate the number of days between two consecutive dates so the calculated field would be DayLapse. (Part of the attendance program allows the most recent point to fall off if an employee has 60 days without a point, the 2 most recent points if an employee goes 150 days with no point and clears all points from their record if they go 210 days with no point).
Could someone point me in the right direction?
I ended adding attachments as when I attempted to paste the data into my thread text it was pretty unreadable. If there is a better way to post, please let me know.
Thank you so much for your help!
I have a table in which the attendance points for each employee is tracked and on which date that attendance point was incurred. I now need a way to calculate the number of days between two consecutive dates so the calculated field would be DayLapse. (Part of the attendance program allows the most recent point to fall off if an employee has 60 days without a point, the 2 most recent points if an employee goes 150 days with no point and clears all points from their record if they go 210 days with no point).
Could someone point me in the right direction?
I ended adding attachments as when I attempted to paste the data into my thread text it was pretty unreadable. If there is a better way to post, please let me know.
Thank you so much for your help!
