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,