Automatically apply new formatting and remove time from a dynamically added Date-Time in google sheets

Question

I am new to Google sheets and don't know how to write excel/google sheet formula to apply automatic formatting to a date+time value added through an external script.

I have a CRM integrated with google sheets, and it dynamically adds current date+time to a google sheet column.

The date format it adds is 2018-04-09T17:49:59 but I want this format to be changed to 2018-04-09 and time(T17:49:59) removed. So the final product is only date 2018-04-09

Here is the image that shows what I meant.

Column C represents what is being added by the CRM and Column D is what I want it to be.

Can anyone please help me to write the proper formula that will format the date and remove the time?

Answer 1

Finally I am able to solve the problem. I used =REGEXEXTRACT(C5,"(.*)T.*") to remove the Time from that string. And going to use the date format as is for now.

The second answer on the following stackoverflow question helped me. https://stackoverflow.com/questions/35164557/remove-characters-from-a-string-after-a-certain-word-excel

Answer 2

1. Highlight the data you want to format.
2. You can adjust the specific formatting for these values by clicking on the arrows in the value and choosing an option.
3. To delete a value from your formatting, click the value and select Delete.
4. Click Apply.