Help

DATETIME_DIFF Formulas Help Needed! Negative Numbers

Topic Labels: Formulas
Solved
Jump to Solution
3372 10
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.