Why is MONTH returning the wrong month?


I'm using the MONTH function against a Created system column. This Created column has date and time. For values on the last day of the month after 8pm MONTH is returning the next month.

For example: Created = 9/30/2021 8:52pm MONTH returns 10

I'm guessing that this is because the system column is actually storing the time based on the time zone the server is in, or perhaps universal time, and then that is adjusted to my time zone when it is displayed, but the MONTH (and probably DAY) functions aren't taking that into account.

Has anyone else experience this? Is there maybe a setting somewhere for the account that can fix it?




Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!