Date Field - Formula Change to (YYYYMMDD)

Cassie_Hall

Hi All,

I want to use a Column Field - Date.

Then want to add another column (only visible for me in sheet) to take date and have this column be a formula to change date format to show YYYYMMDD.

What is the best way to accomplish this?

Thank you!

James Keuning

Use left, right, and mid to parse the date field and recompile it.

(RIGHT([Start Date]@row, 2) + LEFT([Start Date]@row, 2) + MID([Start Date]@row, 4, 2))

Or use YEAR, MONTH, and DAY formulas to do the same thing.

Like this: https://community.smartsheet.com/discussion/53706/convert-date-format-to-yyyy-mm-dd-in-formula-that-combines-date-and-text

L_123

=year([Start Date]@row)+""+month([Start Date]@row)+""+day([Start Date]@row)