power query to clear inconsistent strings in rows

[hood2media]

hi,

ref to "FLT_DATE" column (column-A) in the sample file here. 

kindly advise on how to get rid of the time in the cells under the same column as i found that there are inconsistent i.e. some ending with "00:00" while others end with 12:00:00 AM". 

tks in advc & krgds, -nik

[CNENFRNL · Accepted solution]

= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})

[hood2media]

many tks, @CNENFRNL .

krgds, -nik