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.
Date as column type converts the date into US format but not accurately and hence makes the data ina
Comments
-
Hi Preetha-- The date format you see you in Smartsheet is based on the location indicated for your account. You can click Account (upper left corner) > Personal Settings, change the "Language (Country)" to your location, then click the blue "Save" button. Smartsheet will refresh to display the dates in the format appropriate for your location. Hope this helps!
-
Hi Kennedy - take a look at my comment on this subject: https://community.smartsheet.com/discussion/date-format-inconsistencies-usuk
-
When in doubt whether Smartsheet is confused by the date format (and it can be) use the MONTH() function to be sure if 11/03/16 is March 11th or November 3rd.
Another reason we will never have world peace. Everyone is going to show up, but the other side won't be there because they misunderstood the date.
ISO-8601 or bust!
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives