Forum Discussion
Solved
Date field with unwanted time
Hello I am a beginner of Power BI and am maybe asking a silly question. I am creating a very simple list type report on which there is a date field. Even though I just choose "Date" (without tim...
anada1124 , Check that data type is date and format does and have time.
Second way is have text column using format and use that
format([Date], "mm/dd/yyyy")
amitchandak
Super User
Super Useranada1124 , Check that data type is date and format does and have time.
Second way is have text column using format and use that
format([Date], "mm/dd/yyyy")
Thank you for your advice.
The data type is actually "Date" (without Time) and the format is "yyyy/mm/dd" but the field is exported like "2021-06-09 00:00:00".
I assume I have to use your 2nd solution.
