Reset after anniversary
I have employee data in Ninox, and I have a linked table named attendance points, where each time a time card exception occurs, I add attendance points to their record. I want the points to reset annually after the employees anniversary hire date. I currently have it set that after 365 days from the time card exception, the point drops. How do I fix this?
I am using the if Days>365 then 0 for points, but I want, instead of the points to reset after 1 year of that exception, I want it to reset 1year after the original hire date.
8 replies
-
Now, for employees who have worked for more than a year, I would like the points to reset on each anniversary
-
Hi Stephen,
if you have a start date (Date1) then the date (Date2) after 1 year:
---
Date2:=date(year(Date1)+1,month(Date1),day(Date1))
---
Leo
-
Would the formula work for employees who have worked for 5-6 years as well?
-
bump
-
I do not really understand your question
Date2:=date(year(Date1)+5,month(Date1),day(Date1))
Date2:=date(year(Date1)+6,month(Date1),day(Date1))
Leo
-
I want a formula to apply after each year, on that date. Not just after the first year.
-
Without a data model, I can not understand who you need the formula.
Ninox does not have its own time management. The test must be controlled manually with the Button. The test whether it is today exactly 1 (2,3,4 ....) year, can be formulated in this way.
---
if day(today())=day('Date Field') and mont(today())=month('Date Feld') then .......... else ............. end
---
Leo
-
Without a data model, I can not understand who you need the formula.
Ninox does not have its own time management. The test must be controlled manually with the Button. The test whether it is today exactly 1 (2,3,4 ....) year, can be formulated in this way.
---
if day(today())=day('Date Field') and mont(today())=month('Date Feld') then .......... else ............. end
---
Leo
Content aside
- 6 yrs agoLast active
- 8Replies
- 2310Views