Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
In report builder, I have a datetime field which currently shows as: dd/mm/yyyy hh:mm:ss
How do I remove the time section and have the field only show the date - dd/mm/yyyy
Thank you
Solved! Go to Solution.
I found the answer
FORMAT ( [datetime field], 'dd/mm/yyyy') as Date
I wasn't putting the as Date (or whatever else I want to call that field) part, but once I added that it worked fine.
I found the answer
FORMAT ( [datetime field], 'dd/mm/yyyy') as Date
I wasn't putting the as Date (or whatever else I want to call that field) part, but once I added that it worked fine.
Hi Ry5,
I am dealing with the exact same issue, where do you put this formula? In a calculated field or in Query Designer?
TIA
Hi Gkk!
I know this is late but hopefully it helps someone out there.
You can accomplish this by going into the field value itself. Right-click on the value within the visual you are attempting to format, and select 'Placeholder Properties'. There you can navigate to 'Number', where you can format the number and date, and select the formatting type you'd like for that value.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.