How to rename one column which is a date string

[danial_j]

hi all,

I am wondering if there is a way to rename a column name (and rename it to "Date") which is always a date string but dates can be from any year or any month.

All the rows have dates as strings and have the format "YYYY-mm-dd" i.e. "2019-12-01", "2018-07-30" and column name is also a date string like in the image. So in the example I want to change "2019-01-30" which is a column name to "Date". So that "Date" is my new column instead of "2019-01-30"

Your help will be much appreciated.

[PhilipMannering]

Hi @danial_j 

Rename it to what? And from what?

[PhilipMannering]

This might answer your question. Please see attached!

[danial_j]

hi @PhilipMannering, Thank you for your response.Sorry about the incomplete question. So I have updated my question with a screenshot.

[PhilipMannering]

It might be just me, but I can't see your screenshot..

[danial_j]

aha...So i have attached it as a file now. Could you download it?

[Qiu · Accepted solution]

@danial_j 
if it is just one column, a formula Tool or Dynamic Rename should do it.