Data source issue

[Anonymous]

Hi 

I am trying to clean up some data that I have pulled however there is a date/time column which i would like to change to date but cannot figure out how to remove the time. 
Would anyone be able to help? I have tried to format cells but its not working.

[Anonymous]

its is currently it date/time format - will this method still work?

Yes sorry i forgot to say it is on excel

[regerror6]

Understood.  You may get better responses in an Excel forum (instead of Power BI), but if the value is truely datetime instead of text, you could use the INT function to drop the time component:

=INT(F2)

Try it out to see if it works.

[regerror6 · Accepted solution]

This looks like an Excel question, but if the data is being stored as text, you could parse out the date components based on the position of the slashes.  Here is an example of something that might work by adding another column:

=DATE(
MID(F2,FIND("/",F2,FIND("/",F2,1)+1)+1,4),
MID(F2,1,FIND("/",F2,1)-1),
MID(F2,FIND("/",F2,1)+1,FIND("/",F2,FIND("/",F2,1)+1)-(FIND("/",F2,1)+1))
)

If you are using Power Query, the Detect Data Type button on the Transform tab will convert it from text to datetime.  Then, you could change it to date format.

Hopefully one of these options works!