formatting a date

[biglb79]

Hello, I imported a CSV file into a query format and my date column is showing as this right now: 2019-08-28 03:32:31 EDT

is there a way I can change that to read 8/28/2019? when I change format to date it does nothing. I can do a formula to pull the left numbers, middle and right but I'm hoping there is a better way.

 

[Joe4]

If that value is in cell A1, you can use this formula to get the date (as a valid date):
=LEFT(A1,10)+0

Note that be default it will probably display in General format, so you will need to choose your desired date format.

 

[biglb79]

perfect! thanks so much!

 

[Joe4]

You are welcome.