Forum Discussion

MariaPace's avatar
MariaPace
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's avatar
MariaPace
Qrew Member
4 years ago

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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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's avatar
    MariaPace
    Qrew Member
    4 years ago
    It works, thank you so much!

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