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

Options
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

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    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

  • Shaine Greenwood
    Options

    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.

     

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    Options

    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

This discussion has been closed.