Welcome!

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.

Find more posts tagged with

Comments

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?

Shaine Greenwood

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

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.