Ask Your Question

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

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

DougRB gravatar image

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

1 Answer

Sort by » oldest newest most voted

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

DougRB gravatar image

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 more
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 112 times

Last updated: Jan 14 '20