Change date format

Hello!
How do I change the way a date is displayed? I need to change dates displayed as ""yyyy-mm-dd" to "yyyymmdd" for a report.
Thank you!
Answers
-
Hi @DonnaH ,
First, you'll need to first create a helper column, e.g. "YYYYMMDD". Then modify and use the following column formula below:
=VALUE(YEAR([date column]@row) + "" + IF(MONTH([date column]@row) < 10, "0") + MONTH([date column]@row) + "" + IF(DAY([date column]@row) < 10, "0") + DAY([date column]@row))
You'll just need to substitute the bolded text "date column" to the actual name of your date column. After that, in your report, display the "YYYYMMDD" column.
Cheers,
Ric
-
This works great! Thank you!
-
I need to change the date format on my Smartsheet to a UK format 'dd/mm/yy' how is this possible
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!