Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Insert custom DATE field format

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?