I have a column in a QGIS attribute table that contains elapsed time (in years). I have created an additional column in the attribute table to convert the elapsed time to a date. I am using an expression using the open field calculator to add the elapsed time to the current date. The expression I am using is now() + to_interval(concat("elapsed_time"),' years')), with elapsed time being the elapsed time column.
Everything works fine but when the elapsed time becomes greater than ~68 years, the output date reverts back to 1950, instead of correctly adding the number of years to the current date. I have tried to use other dates besides the current date and get the same results. Does anyone have any ideas of why this happens and how to fix it?