topic Re: Date Field in Pivot Table Exporting to Excel With Incorrect Formatting in QlikView https://community.qlik.com/t5/QlikView/Date-Field-in-Pivot-Table-Exporting-to-Excel-With-Incorrect/m-p/75873#M1324099 <HTML><HEAD></HEAD><BODY><P>FYI, I just came up with a workaround where I'm specifying format 'M/D/YYYY' in the Date function (it's Date(Floor(datefield), 'M/D/YYYY') now instead of just Date(Floor(datefield))). While this works, it doesn't help all the other date fields that we have throughout our dashboards that I would have to find manually. Any idea why this behavior would change between 11.20 and 12 would be very much appreciated. Thanks.</P></BODY></HTML> Thu, 08 Feb 2018 20:23:47 GMT lgtsotrsdh 2018-02-08T20:23:47Z Date Field in Pivot Table Exporting to Excel With Incorrect Formatting https://community.qlik.com/t5/QlikView/Date-Field-in-Pivot-Table-Exporting-to-Excel-With-Incorrect/m-p/75872#M1324098 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We're upgrading from QlikView 11.20 to QlikView 12 November 2017 SR2 and have run into a weird issue while testing. We have a Straight Table that has three date fields in the table. When we export this table to Excel, everything looks good. However, if we do a Fast Change to a Pivot Table and do the same export, we get incorrect formatting for only one of the data fields. I've checked the formatting in the Document Properties and it matches the other date fields that export correctly. I tried to change it from M/D/YYYY to MM/DD/YYYY and we're still getting the same thing. Has anyone seen this issue? Any idea what's going on?</P><P></P><P>Thanks,</P><P>Scott</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Date-Field-in-Pivot-Table-Exporting-to-Excel-With-Incorrect/m-p/75872#M1324098 lgtsotrsdh 2026-01-26T18:19:17Z Re: Date Field in Pivot Table Exporting to Excel With Incorrect Formatting https://community.qlik.com/t5/QlikView/Date-Field-in-Pivot-Table-Exporting-to-Excel-With-Incorrect/m-p/75873#M1324099 <HTML><HEAD></HEAD><BODY><P>FYI, I just came up with a workaround where I'm specifying format 'M/D/YYYY' in the Date function (it's Date(Floor(datefield), 'M/D/YYYY') now instead of just Date(Floor(datefield))). While this works, it doesn't help all the other date fields that we have throughout our dashboards that I would have to find manually. Any idea why this behavior would change between 11.20 and 12 would be very much appreciated. Thanks.</P></BODY></HTML> Thu, 08 Feb 2018 20:23:47 GMT https://community.qlik.com/t5/QlikView/Date-Field-in-Pivot-Table-Exporting-to-Excel-With-Incorrect/m-p/75873#M1324099 lgtsotrsdh 2018-02-08T20:23:47Z