https://bugs.documentfoundation.org/show_bug.cgi?id=80177
--- Comment #24 from Andreas Säger <[email protected]> --- (In reply to mshiner from comment #23) > > Mike notes "Excel relies on per-field format setting in pivot tables, while > Calc > takes fields formatting from source." which I think is where the problem > resides. > A database knows dates as a distinct data type. There should be no disambiguation about the actual data type. In Base you can also declare the prefered display format of a date field in table design (but not in query design). However, doing so makes no difference. The dates come in as serial day nummbers (LO 7.2.2) -- You are receiving this mail because: You are the assignee for the bug.
