Change date format

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!

Ric T

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

DonnaH

This works great! Thank you!

Lenore

I need to change the date format on my Smartsheet to a UK format 'dd/mm/yy' how is this possible