Ask Your Question

TEXTJOIN with dates

asked 2018-08-13 17:43:18 +0100

cukabeka gravatar image


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)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-08-13 19:27:39 +0100

JohnSUN gravatar image

(To illustrate the answer of @Mike Kaganski )

(To illustrate the answer)

edit flag offensive delete link more


Thanks! :-)

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-13 20:09:47 +0100 )edit

answered 2018-08-13 18:51:32 +0100

updated 2018-08-13 18:51:48 +0100

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-13 17:43:18 +0100

Seen: 804 times

Last updated: Aug 13 '18