Report Builder ( paginated report ) remove time from date field

[Ry5]

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

[Ry5 · Accepted solution]

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.

[Gkk]

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