I formatted a field in a table as YYYY. No matter what date I imput, it reverts to 1905, i.e. 2007 becomes 1905 or 2013 becomes 1905, etc. Is there a way to only show the correct year? I have several dates in the 1800’s. Thanks.
I changed as suggested to Number, General. In the first record I entered 2006 and got 2006. In the second, I entered 2007 and got 2009. It added 2 for every record after the first one.
I get no such results. Post a sample DB with the problem in your edited question.
Also your comment should have been attached to the answer you are responding to. As is you are responding to the question.
Hello,
Would say it is probably because this is not a date field. With date and numeric field as YYYY:
With YEAROFBIRTH reset to General format:
Definitely. Year 1905 is days 1828 (1905-01-01) to 2192 (1905-12-31) in LO’s internal format (days since 1899-12-30); so numbers that one might realistically enter into such a field would all fall into that range. Even if DB’s DATE is not exactly the same (e.g. using a slightly different epoch), it’s still similar and follows the same logic.
Thank you. Of course this is logical. Sometimes I don’t see the forest through the trees.