TEXTJOIN with dates

HI,

I want to use textjoin on a column that has dates like this. The cells are formatted as date.

31.07.2013 10:30:00
26.07.2013 16:00:00

Now if I use TEXTJOIN on this, some weird numbers are shown, but nothing that has to do with the dates:

43307,4166666667, 43305,4166666667

Is this a bug or did I miss something?

(LO 6.1 on OSX)

(To illustrate the answer of @mikekaganski )

(To illustrate the answer)

Thanks! :slight_smile:

This is not a bug. TEXTJOIN takes cell value, not a cell’s formatted display text. Dates are internally numeric values, which are number of days from LibreOffice’s configurable epoch. So taking the underlying number, it displays it to you unformatted.

You could use TEXT function to control the text format.