Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
BUG: DAY() against the Created column sometimes returns wrong day
When using the DAY() function on the system generated Created column, a time zone issue surfaces in late hours. For the Eastern Time Zone, DAY(Created N) sometimes returns the next day. For example =DAY(Created1) where Created1 = "05/17/17 10:32 PM" returns 18. See snapshot. Please advise. Thank you.
Comments
-
Try checking your Settings > Personal Settings > Profile Time Zone setting. You may not be set to the correct time zone. See if adjusting the time zone helps?
-
I'm wondering if this DAY is returning an unexpected date because of the time element of the System column.
Try using =DAY(DATEONLY(Created1)) to make sure that only the date component is present in your formula.
-
This is a known issue and documented elsewhere on the Community.
The issue is that the displayed date is based on your personal settings but the underlying value is based on UTC.
I've personally reported and documented this several times.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives