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.

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")
)