Convert text to Date

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, 

0 0 221
0 REPLIES 0
Top Labels in this Space
Top Solution Authors