Forum Discussion

GregSchroeder's avatar
GregSchroeder
Qrew Trainee
7 years ago

Need to add 40 to the a numeric field value after a certain number of days pasts in another date field. Can anyone please help! Thanks!

Hello,relatively new to quick base here. I'm trying to track my employees available vacation time in a field AND automatically add 40 days to that field after their start date reaches 2 years ago ( ...
Forms
Quickbase Automations
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Greg, this field is meant to calculate the vacation entitlement.  Typically there will be a child table on the Employee (EE) record to record each vacation instance.  Then a summary field back up to the EE record to calculate the total vacation taken during the year.

That way everyone can know what the details were for the vacation taken.

As for the formula not working, can you give me an example of a EE and their start date that you feel is not calculating correctly?