Forum Discussion
Convert text to date - Inconsistency
Hi, hoping someone might be able to shed some light on the following. I've connected to an Online SharePoint list that has just over 19000 entries. When viewing the data in PowerBI i noticed ...
Thanks for the message and idea!
I ended up using the extract before deliminator function to just extract the date and then re-ran Detect Data Type. Thankfully this worked!
Perhaps you could do a Split on the column and then create a new column using the #date constructor to ensure that you construct the dates correctly?
https://msdn.microsoft.com/en-us/query-bi/m/sharpdate
Thanks for the message and idea!
I ended up using the extract before deliminator function to just extract the date and then re-ran Detect Data Type. Thankfully this worked!