Convert text to Date

[rodbotto]

Hi i have a google sheet that is the data source for looker. One of the dates is inthe following format - 11/27/2023 at 08:00 AM. How can I turn this into a date only - MM/DD/YYYY or any other format so i can use it in looker? No need for time data. 

thanks, 

[GavinW]

There may be smarter ways to do this, but one approach is to just create a new column that extracts the date characters from your existing field. Something like this will work: 

You can use DATEVALUE to convert this into something sheets recognises as a date, and also format the cell to have the date shown the way you want to see it.