Forum Discussion
dave1545
Jul 29, 2024Copper Contributor
Changing Dates in a Column ... and more lol
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.
- ChReedCopper ContributorThere were formatting options to make the timestamps not display, but if they aren't working I have a possible clunky option for you. Make a new column and us =Mid, =LEFT or =RIGHT. I am not sure where the time stamp is, but let's say it's before the date. In that case you would use the formula =RIGHT(cell reference you string is currently in, 6). The '6' is the number of characters you want to pull - you will have to adjust this based on how your data is structured.
Not a great solution, but it might be faster than digging more... Hope you figure it out!- ChReedCopper ContributorI don't think so, as I have read documentation stating this should work BUT something may have changed there that I am not aware of. Wish I could be more specific!