Ask Your Question

Insert custom DATE field format [closed]

asked 2014-01-19 09:17:25 +0100

Cynical gravatar image


I am creating a table, which has a year field of type Date [DATE]: this field will contain only the year so, since it's not among the pre-existing formats, I created a new one using the AAAA format code, which is the YYYY for my locale (as stated in the Libreoffice docs).

The problem is that, even if I receive no errors in doing this, when I enter a date such as 1485 it is changed into 1904. This happens with every date, and the "resulting" field is changed as well with no clear pattern: sometimes I get 1905, sometimes 1999, or else.

So my question is: is it possible to use the DATE type and provide only the year?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 17:09:11.731940


Internal Date structures and their representation were changed in LibreOffice 4.1 - see release notes to check whether this affects your use case.

Alex Thurgood gravatar imageAlex Thurgood ( 2014-08-11 11:14:48 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-01-19 12:41:40 +0100

ROSt52 gravatar image

As far as I know there is a basic problem in dates using a date format if dates are before or after a certain year.

Do you need the date format? if not there is no problem entering old dates as numbers.

edit flag offensive delete link more

answered 2014-01-19 12:56:55 +0100

oweng gravatar image

It may be easier to use a formatted field as indicated in this thread.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-19 09:17:25 +0100

Seen: 2,076 times

Last updated: Jan 19 '14