Export Customer Reports adds time into Date

Shopify Discussion
1

I’m trying to figure out my Lifetime Customer Value.

In reports i use “Customer Predicted Spending Tier”

So i do an Export into my Google Sheets and the Dates add time ,

I only want the dates, everything after T needs to be removed. How can i fix this, Is there a way to remove this in Google Sheets automatically. or is it a setting on Shopify i’m missing

dates look like this

2021-08-23T22:46:50-04:45

2

Hi,

A simple way to fix this in google sheet is to use the Split text to columns.

You select the column with the date & times.

In the menu you go to Data → Split text to columns

You select Custom for delimitator and enter the letter T

It should do the trick… you can later delete the column with the time part.

Good luck,

Peter @ Datma - Product analytics & more