Why does =TODAY() - Created@row give inconsistent results?
I have an auto number column [Created] that captures the time a row is created. In another column [AGE], I am trying to calculate the age by using the formula =TODAY() - Created@row. For some of the rows created today, this formula gives an AGE of 0 days, but for others it results in -1. What am i doing wrong?
Best Answers
-
Hi,
It's a system time issue with Created. The time zone doesn't match your time zone so during some hours the calculation appears to be wrong. There are several posts about it in the Community. There are also a couple solutions from @Paul Newcome .
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks Mark!
Answers
-
Hi,
It's a system time issue with Created. The time zone doesn't match your time zone so during some hours the calculation appears to be wrong. There are several posts about it in the Community. There are also a couple solutions from @Paul Newcome .
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks Mark!
Help Article Resources
Categories
Check out the Formula Handbook template!
