Daily values by column not recognized as a date


I have created a pivot table in LO calc. My source data is in the same file, on 7 columns and 105 rows.
One column (“Day”) has daily values, e.g. 03/21/2017, 03/11/2014, etc…

in the pivot table configuration, i set the field “Day” by column, and the result is following column headers (11 columns in this example) :

  • 41642 41643 41644 41645 41646 41647 41648 41649 41650 41651 41652

Obvisouly, the daily values are not recognized as such by the software.

On the contrary, if i set the field “Day” by row, the result is:

  • Tuesday, March 21 2017
  • Tuesday, March
    11 2014

Can anyone help ?
My goal is to set the day by column, and in a next step to group the days by year and month.

Many thanks in advance,

LO Calc version


I reproduce the problem… but I dot not reproduce if I move the Data field in the Row Fields:

See DayColumn.ods


Thanks pierre-yves samyn for looking on my problem.
From your screenshot i don’t see that you reproduced the issue. The day values in the column headers of the pivot table are correct, aren’t they ?

I attach a screenshot to show the issue from my side.

Thanks and regards

@Wololo: my screenshot shows the result after the workaround (mode Data field in Row Fields).