Forum Discussion
Excel Power Query - how to truncate data that is returned date time to just date
In the Transform-Tab, you'll find some options in the "Date"-section that allow to extract just the date.
If that doesn't work, you can retrieve everything before the "T" with a text-extraction-function:
Thank you - that got me on the right track ... I was able to truncate off the time by going to the Transform-Tab, selecting Date, and then choosing Date Only ... greatly appreciate the assist!
In the Transform-Tab, you'll find some options in the "Date"-section that allow to extract just the date.
If that doesn't work, you can retrieve everything before the "T" with a text-extraction-function:
Thank you - that got me on the right track ... I was able to truncate off the time by going to the Transform-Tab, selecting Date, and then choosing Date Only ... greatly appreciate the assist!