date Format

[Hamidrezaei]

Hi Guys, 

I am having an issue with date format as some of the columns are yyyy/mm/dd 00:00:00 and others are like yyyy-mm-dd 00.00.00

I could change the first format to show only dates yyyy/mm/dd, but when I try to change the format for the other columns to date only it gives me an error. is there any way to fix that?

Thank you 

[v-eachen-msft · Accepted solution]

Hi @Hamidrezaei ,

If you only want the date, you could split this column based on space.

Here is my test result.

Now you could remove another time column or transform it, it is up to you.

[AlB]

Hi @Hamidrezaei 

replace the . with  with : and it should work with both  yyyy-mm-dd 00:00:00 and yyyy/mm/dd 00:00:00

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers