I wanted to change the date format in a column. There are a few issues; first is that presently, the column that contains dates, also has a time in each entry. So, I do not know how to remove the times, if they can be at all. Second, is that the date is presently not showing as yyyy-mm-dd. I followed the prompts to changing them to that, however it di not happen (!?) Is it because there is a time involved? There are 5000 rows, so I cannot do this manually. All suggestions and definitely a walk through would be awesome. Thank you.

​I wanted to change the date format in a column. There are a few issues; first is that presently, the column that contains dates, also has a time in each entry. So, I do not know how to remove the times, if they can be at all. Second, is that the date is presently not showing as yyyy-mm-dd. I followed the prompts to changing them to that, however it di not happen (!?) Is it because there is a time involved? There are 5000 rows, so I cannot do this manually. All suggestions and definitely a walk through would be awesome. Thank you.  Read More

​