Ask Your Question

Any Base guru tell me, a confessed newbie why the date is stuck on 12/1899?

asked 2020-01-15 23:36:09 +0100

kola gravatar image


No matter what I write in my date column that is formatted too MM/YYYY it wont budge from 12/1899 that also happens to be the example in the Field Format box under the Language selection box.

What can I possibly be doing wrong.

PS Thank you for this brilliant free software.

edit retag flag offensive close merge delete


PS Thank you for this brilliant free software.

Understand, you are dealing LO users on this site just trying to help other users.

Also in the future, please include you specific LO version, OS and for Base the database being used. This can make a difference in the approach to an answer.

Thank you.

Ratslinger gravatar imageRatslinger ( 2020-01-16 00:48:30 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-01-16 12:31:15 +0100

kola gravatar image

Thanks for replies.

I switched from MM/YYYY to DD/MM/YYYY and now it works fine. Annoying though, only need month and year.

edit flag offensive delete link more

answered 2020-01-16 00:30:21 +0100

Ratslinger gravatar image

updated 2020-01-16 00:35:35 +0100


This appears to be a bug. Please report here -> Bugzilla

You can currently enter a correctly displayed date using MM/DD/YYYY format (just use 01 for DD) and it will display as MM/YYYY.

Please understand that in databases, regardless of entry or display method, the date will be stored as YYYY-MM-DD.


Strangely, if I enter 01/20 the date will result in 01/2020.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-15 23:36:09 +0100

Seen: 44 times

Last updated: Jan 16