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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives