Forum Discussion
Solved
power query to clear inconsistent strings in rows
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
= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})
2 Replies
= Table.TransformColumns(#"Changed Type", {"FL_DATE", each Date.FromText(Text.BeforeDelimiter(_, " "),[Format="M/dd/yyyy"])})many tks, CNENFRNL .
krgds, -nik
