Created attachment 116584 [details] Example with LO 4.2.8.2 / Ubuntu 14.10 LTS (screenshot) When I create a pivot table from a database registered in LibreOffice, throw a query or not, the Dates get number format. Whereas dates are formatted well in the autofilter button, for example (please look at screenshot attached). It's the same problem, I think that mshiner's one on the bug report n° 80177. But I don't use PostgreSQL or other connection like that. My database is made of only one Excel5.0 file stored on a Windows Server. I tried with a file and database stored locally : same result. I tried with a dbf file instead of Excel : same result. I tried add a sheet linked to the source file on the same file of the pivot table (so no database needed) : Dates format is ok. I had this problem first when trying LO 4.0.0 beta. It can be reproduce with LOdev 5.0.0.0 beta3. So I still use LO 3.6.5.2 for this kind of processing. There's the same bug in Apache OpenOffice 4.0.1 but it's fixed on AOO 4.1.0.
Hi @Anthony, thanks for reporting. Seems a duplicate, please if you are not agree reopen it. *** This bug has been marked as a duplicate of bug 80177 ***