Forum Discussion

Qrew Member

4 years ago

Calculate year and month tenure from two dates

I have a form with start date and end date. How do I calculate tenure in years and months (e.g., 3 years 4 months) based on these two dates? ------------------------------ Maria Pace ------------...

Formulas and functions

MariaPace

Qrew Member

Thanks! I made the changes but get the error "Expecting duration but found text" at $RawResult. Should I change the formula type?

------------------------------
Maria Pace
------------------------------

MarkShnier__You

Qrew Legend

4 years ago

Yes, if the result is to be in words then yes change the formula type to formula text.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

MariaPace
Qrew Member
4 years ago
It works, thank you so much!

------------------------------
Maria Pace
------------------------------