Forum Discussion
Solved
Trying to pull only date info from cells
Hello all,
I have a column of information that displays data in the below format:
I am trying to create a separate column that ONLY pulls the date information and not the timestamp. Any suggestions would be appreciated!
Hi Th1sGuy , go to power query and use the split column functionality to get the date :
This will provide you the date column :
2 Replies
- AnkitaaMishra
Super User
Hi Th1sGuy , go to power query and use the split column functionality to get the date :
This will provide you the date column :
- GeraldGEmerick
Memorable Member
Th1sGuy Do a Split Column by Delimiter and use a Custom delimiter of " at ". Remove the extra column.
#"Split Column by Delimiter" = Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter(" at ", QuoteStyle.Csv), {"Column1.1", "Column1.2"}),
