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

vitwnow
vitwnow ✭
edited 12/09/19 in Archived 2017 Posts

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.

ss-day-function.JPG

· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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? 

    2017-05-18_08-55-32.png

    · Share on FacebookShare on Twitter
  • Shaine Greenwood
    Shaine Greenwood Employee

    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.

     

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories