Help

Re: DATETIME_DIFF Formulas Help Needed! Negative Numbers

Solved
Jump to Solution
1436 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Penny_Bell
5 - Automation Enthusiast
5 - Automation Enthusiast

Why are all my DATETIME_DIFF formulas coming up as a negative number?

My formula is: DATETIME_DIFF({Birthday}, TODAY(), ‘years’) and I am getting for example -29 instead of 29.

10 Replies 10

No, the curly braces had nothing to do with it. It was the quotation marks that were the problem.