topic Report Builder ( paginated report ) remove time from date field in Report Server

Report Builder ( paginated report ) remove time from date field

Ry5 — Thu, 26 May 2022 04:20:34 GMT

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

Re: Report Builder ( paginated report ) remove time from date field

Ry5 — Thu, 26 May 2022 06:01:30 GMT

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.

Re: Report Builder ( paginated report ) remove time from date field

Anonymous — Fri, 01 Dec 2023 13:51:20 GMT

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

Re: Report Builder ( paginated report ) remove time from date field

bfernandez — Wed, 31 Jul 2024 14:48:25 GMT

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.

Re: Report Builder ( paginated report ) remove time from date field

gtiwari11 — Thu, 14 Aug 2025 15:00:39 GMT

There is New solution found : EVALUATE
SUMMARIZECOLUMNS(
'DimDate'[WeekEnding],
"FormattedWeekEnding", FORMAT(min('DimDate'[WeekEnding]), "MM-dd-yyyy")
)