Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
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
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |