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!

Tags:

Answers

  • Ric T
    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
    DonnaH ✭✭✭

    This works great! Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!