cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ry5
Frequent Visitor

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
Frequent Visitor

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

1 REPLY 1
Ry5
Frequent Visitor

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.

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!