Ask Your Question
0

TEXTJOIN with dates

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

cukabeka gravatar image

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)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

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

JohnSUN gravatar image

(To illustrate the answer of @Mike Kaganski )

(To illustrate the answer)

edit flag offensive delete link more

Comments

Thanks! :-)

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

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

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

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

Stats

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

Seen: 222 times

Last updated: Aug 13 '18