Why does =TODAY() - Created@row give inconsistent results?

tariq.shaikh@signspecialists.com

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?

Mark Cronk

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

tariq.shaikh@signspecialists.com

Thanks Mark!

Mark Cronk

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

tariq.shaikh@signspecialists.com

Thanks Mark!