how to extract date from datetime column in google sheet using query funtion(SQL)-CodePudding

Home > Back-end > how to extract date from datetime column in google sheet using query funtion(SQL)

how to extract date from datetime column in google sheet using query funtion(SQL)

Time：11-12

Column value is shown in the figure and I am trying to extract the date from the datetime column.

enter image description here

I m trying to use the following command

=QUERY(A:B, "Select A where B is not NULL '"&SPLIT(A2:A," ")&"'",1)

CodePudding user response：

Try

=ArrayFormula(IFERROR(DATEVALUE(REGEXEXTRACT(A1:A,"(. ) "))))

CodePudding user response：

try:

=INDEX(1*SPLIT(A1:A10; " ");;1)

and set formatting to Date