topic Date on a pivot table in QlikView https://community.qlik.com/t5/QlikView/Date-on-a-pivot-table/m-p/193012#M54457 <HTML><HEAD></HEAD><BODY><P>Hi ... first sorry for my bad english..</P><P></P><P>I have a view on the sql that has a datetime field...</P><P>I want to view only the date (day/month/year) on the pivot table and not all the field with the hour...</P><P></P><P>how can i do??</P><P></P><P>Thanks</P></BODY></HTML> Thu, 25 Mar 2010 09:35:21 GMT 2010-03-25T09:35:21Z Date on a pivot table https://community.qlik.com/t5/QlikView/Date-on-a-pivot-table/m-p/193012#M54457 <HTML><HEAD></HEAD><BODY><P>Hi ... first sorry for my bad english..</P><P></P><P>I have a view on the sql that has a datetime field...</P><P>I want to view only the date (day/month/year) on the pivot table and not all the field with the hour...</P><P></P><P>how can i do??</P><P></P><P>Thanks</P></BODY></HTML> Thu, 25 Mar 2010 09:35:21 GMT https://community.qlik.com/t5/QlikView/Date-on-a-pivot-table/m-p/193012#M54457 2010-03-25T09:35:21Z Date on a pivot table https://community.qlik.com/t5/QlikView/Date-on-a-pivot-table/m-p/193013#M54458 <HTML><HEAD></HEAD><BODY><P>Date(Fecha) as Fecha</P></BODY></HTML> Thu, 25 Mar 2010 09:57:46 GMT https://community.qlik.com/t5/QlikView/Date-on-a-pivot-table/m-p/193013#M54458 2010-03-25T09:57:46Z