Date on a pivot table

[#1]

Hi ... first sorry for my bad english..

I have a view on the sql that has a datetime field...

I want to view only the date (day/month/year) on the pivot table and not all the field with the hour...

how can i do??

Thanks

[#2 · Accepted solution]

Date(Fecha) as Fecha