I have a column
StartDate and I want to calculate the time difference in years from that date to the current day. For example:
My start date of work is 4/19/2016, it will be 5 years until 4/19/2022 then it will calculate 6 years. How can I achieve this?
I have tried the following:
Created a Today Date & Time Column, where the default value is Today's Date.
YearsHere Column, that has the following calculated value:
And it returns something like, 108. Say the Start Date is 6/22/2020, the
YearsHere column will show 120? Why is that.
So, the today column is empty. Is there a workaround