Forum Discussion
MariaPace
4 years agoQrew Member
Thanks! I made the changes but get the error "Expecting duration but found text" at $RawResult. Should I change the formula type?
MarkShnier__You
4 years agoQrew Legend
OK, let's go back to basics, maybe I have way over complicated this.
Can you give me an example of the start date and the end date and the response you want from the formula.
If you just want the Duration then you just subtract
[End date] - [Start Date]
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Can you give me an example of the start date and the end date and the response you want from the formula.
If you just want the Duration then you just subtract
[End date] - [Start Date]
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- MariaPace4 years agoQrew MemberThe duration works but I get it in days and would like it in year and month. So if start date is 11/01/2020 and end date is 12/05/2021 the duration would be 1 year 1 month.
------------------------------
Maria Pace
------------------------------- MarkShnier__You4 years agoQrew LegendCan you post your current formula with a copy paste (not a screenshot)?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------