DateOnly YearDay off a day Time Zone Question
Hello. I have a question about the DateOnly and YearDay functions. Please see below (Pic 1). All dates after 7pm gets moved to the next day for the DateOnly and YearDay functions. I am assuming, not 100%, this is a Time Zone issue as I live in UTC -5 hours.(Pic 2). I saw a post (Pic3) that said that Smartsheet captures dates and times in UTC but displays the value accordingly to your personal setting. Since I live in UTC time zone and my personal settings are set to UTC, What else could cause this? Thank you.
Previous post in 2018