Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ry5
Helper I
Helper I

Report Builder ( paginated report ) remove time from date field

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

1 ACCEPTED SOLUTION
Ry5
Helper I
Helper I

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.

View solution in original post

3 REPLIES 3
Ry5
Helper I
Helper I

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.

 

bfernandez_0-1722437248331.png

 

bfernandez_1-1722437285445.png

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors