why does date display as 5-digit number instead of dd/mm/yyy?

asked 2020-01-10 19:21:06 +0100

DougRB
11 ●2 ●4 ●5

Until recently LOBase has been displaying dates normally as dd/mm/yyyy, but has suddenly taken to displaying the dates in tables and queries in one of my DBs as as 5-digit numbers, eg. 43801. If I copy the table into a spreadsheet the date fields show up correctly. Another LO database on my computer is OK. How do I get this particular DB to behave properly? Linux MDE3; LO 6.0,6.1,6.3

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2020-01-14 14:50:42 +0100

DougRB
11 ●2 ●4 ●5

ANSWER: haven't found the reason, but I can work around it as follows: (1) Copy and paste the defective table to a new one, taking only the definition, but no data (2) Copy the defective table to a spreadsheet - there, the dates are shown correctly (3) Append the spreadsheet data to the new DB table. The copying produces an error message about incorrect format, but go ahead just the same.

The appended data in the new table show the dates correctly.

edit flag offensive delete link

add a comment

Question Tools

1 follower

Stats

Asked: 2020-01-10 19:21:06 +0100

Seen: 112 times

Last updated: Jan 14 '20

why does date display as 5-digit number instead of dd/mm/yyy? edit

1 Answer

Question Tools

Stats

Related questions

why does date display as 5-digit number instead of dd/mm/yyy?