Change date format
Options
DonnaH
✭✭✭
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!
Tags:
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!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!