From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/guide/year2000.xhp | 51 +++++++++++++++++++++++ 1 file changed, 51 insertions(+) create mode 100644 helpcontent2/source/text/scalc/guide/year2000.xhp (limited to 'helpcontent2/source/text/scalc/guide/year2000.xhp') diff --git a/helpcontent2/source/text/scalc/guide/year2000.xhp b/helpcontent2/source/text/scalc/guide/year2000.xhp new file mode 100644 index 000000000..8ff336c55 --- /dev/null +++ b/helpcontent2/source/text/scalc/guide/year2000.xhp @@ -0,0 +1,51 @@ + + + + + + + + +19xx/20xx Years +/text/scalc/guide/year2000.xhp + + +Sun Microsystems, Inc. + + + +years; 2-digits +dates; 19xx/20xx + +19xx/20xx Years + +
+The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years. + + +Under %PRODUCTNAME - PreferencesTools - Options - $[officename] - General you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029. + + +This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020. +
+
+ +
+ + -- cgit v1.2.3