Insert custom DATE field format

English
, ,
#1

Hi!

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?

#2

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

#3

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.

#4

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

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.