Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values refering to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified foe dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values refering to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified foe for dates before 1582 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2) V5.2.2)

Probably the OQ worried about the Gregorian calendar reform. Nearly Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values refering to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values refering referring to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values referring to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000 or earlier. What a disgrace!)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values referring to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000 or earlier. What a disgrace!)0000.)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values referring to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000.)0000.) Supposing that the application of the proleptic Gregorian calendar was intended, year 0000 should be accepted and years outside the range [0;9999] should either throw an error under the mentioned format or automatically be transferred to "+YYYYY-MM-DD" applying the sign only to the year part. Fortunately the two of us do not know ancestors from year 0 or earlier.

(This answer only is about Calc. I am not enough experienced with Base.)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values referring to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000.) Supposing that the application of the proleptic Gregorian calendar was intended, year 0000 should be accepted and years outside the range [0;9999] should either throw an error under the mentioned format or automatically be transferred to "+YYYYY-MM-DD" applying the sign only to the year part. Fortunately the two of us do not know ancestors from year 0 or earlier.

(This answer only is about Calc. I am not enough experienced with Base.) Base and things may depend there on the underlying wrapped-in database engine or the one connected.)

Probably the OQ worried about the Gregorian calendar reform. Nearly everything will also work with older dates.

Details:
In fact the DATE function does not accept parameter values referring to days earlier than 1582-10-15 the first day of the new calendar. You may, however, enter also 1582-10-04 the last day the reform was not in effect. The difference of the numeric values of the two days will be 1 then which is correct. (=DATEVALUE("1582-10-15") - DATEVALUE("1582-10-04") will return 1.) DATEDIF is also applicable. "Undates" like 1582-10-11 will not be recognised as dates when entered but will be treated as text. DATEVALUE will return Err:502 in the case. The ISLEAPYEAR function is not specified for dates before 1582 though it will not return an error but wronly apply the Gregorian rule (last tested with V5.2.2)

Plaese note: The central ISO 8601 conforming date format using the format code "YYYY-MM-DD" in many locales, (displayed using the example 1999-12-31) does not correctly apply the mentioned standard for dates in year 0000.) Supposing that the application of the proleptic Gregorian calendar was intended, year 0000 should be accepted and years outside the range [0;9999] should either throw an error under the mentioned format or automatically be transferred to "+YYYYY-MM-DD" applying the sign only to the year part. Fortunately the two of us do not know ancestors from year 0 or earlier.