Help

update number field annually based on date field

Topic Labels: Formulas
547 1
cancel
Showing results for 
Search instead for 
Did you mean: 
LB_MHIR
4 - Data Explorer
4 - Data Explorer

I'm trying to figure out if there's a way to update a number field annually based on date. I've got a Position Start Date field, a Year of Experience On Entry field which is a number field that reflects the year(s) of experience the person had as of their position start date, and I want to create a field that adds +1 to the number in the Year of Experience On Entry field annually on their Position Start Date, and that field will be called to Current Year of Experience. Is there a way to write a formula that will calculate the Current Year of Experience?

POSITION START DATEYEAR OF EXPERIENCE ON ENTRYCURRENT YEAR OF EXPERIENCE
1/15/202201
6/12/2300
4/13/201816

Thank you for any thoughts you might have on this!

1 Reply 1

Try DATETIME_DIFF({Position Start Date}, TODAY(), ‘years’)+ {Year of Experience on Entry}.

You might need to switch the dates in the DATETIME_DIFF() formula. I can never remember if it’s From, To or To, From.