Forum Discussion

Ry5's avatar
Ry5
Icon for Helper I rankHelper I
4 years ago
Solved

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

Date
DateTime
Paginated Report
report builder
  • Ry5's avatar
    Ry5
    4 years ago

    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.

4 Replies

  • gtiwari11's avatar
    gtiwari11
    Icon for Advocate I rankAdvocate I
    1 year ago

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

  • Ry5's avatar
    Ry5
    Icon for Helper I rankHelper I
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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

      • bfernandez's avatar
        bfernandez
        Icon for Resolver II rankResolver II
        2 years ago

        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.