Does time of day factor in for "Auto-Number/System - Modified" Column filters?

Shelby Nielsen

Hello Smart Friends!

Im using the Auto System modified column but Im getting all kinds of wonky results when I filter. Ive tried using greater than, greater than equal too, is between, is in the past (days) etc and I keep getting all kinds of off results. I have 89 rows, 41 modified on 1/13, 6 on 1/14, and 19 on 1/15.

Trying modified is greater than - When I select 1/13 or 1/14 all 89 columns are shown. When I select 1/15, 4 of the 6 rows modified on 1/14 still show in results and all 1/15 rows.

Trying the past (5) days today, Jan 19th, I see all results from the 13th -18th but nothing today. If I try 4 days I see 4 out of 6 of the rows for 1/14. These 4 have timestamps after 6PM.

Other than manually selecting all of the different time stamps Im not finding a way to get true results. Im trying to view changes in the past week for a recurring weekly call. Any suggestions?

Mark Cronk

Hi @Shelby Nielsen ,

Sounds like you're experiencing a known issue with Created and modified system columns. These columns have time and date stamps but behind them the time is UTC. So, your time zone will give you different results when using a date function in calculations. @Paul Newcome is the time guru. His link to all things time is below. You should find a solution there.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Hope that helps.

Mark

Mark Cronk

Hi @Shelby Nielsen ,

Sounds like you're experiencing a known issue with Created and modified system columns. These columns have time and date stamps but behind them the time is UTC. So, your time zone will give you different results when using a date function in calculations. @Paul Newcome is the time guru. His link to all things time is below. You should find a solution there.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time

Hope that helps.

Mark

Shelby Nielsen

This is perfect! Thanks @Mark Cronk & @Paul Newcome

Mark Cronk

Happy to help. Thanks for contributing to the Community.

Mark

Paul Newcome

Happy to help. 👍️