Suppress the Date() limitation

[charvista]

I believe it is now high time to support years after 2037.

Code: Select all

For i=2019 To 2040
    Debug Str(i)+" : "+Date(i,12,31,23,59,59)
Next i

[davido]

+1

[Tenaja]

+1

[BarryG]

+1

[thyphoon]

+1 and before 1970

[Seymour Clufley]

+1

[wayne-c]

+1 and before 1970

+1000000

[Rinzwind]

Yup, very silly that the 64 bit version didn't extend the range. We're stuck with a very limited date range. 2039 is the end-of-ages (or PB) apparently

[Lord]

+1 and before 1970

That's gonna be a little difficult.
How far back should the date go?
Remember: There are many dates when the Gregorian
calendar was introduced in different parts of the world.
You have to check for each area which calendar was
valid on the corresponding date.

[thyphoon]

The Gregorian calendar is the internationally accepted civil calendar that was first adopted in 1582

[Lord]

The Gregorian calendar is the internationally accepted civil calendar that was first adopted in 1582

...but wasn't introduced in every part of the world at the same time.

[thyphoon]

...but wasn't introduced in every part of the world at the same time.

Yes but, who can do more can do less.
the majority will use it for dates until 1900 or maybe 1800 but not before.

[C87]

In England the Gregorian calendar was used from 1752 if I recall correctly. For anyone who has involved themselves in geneology they will have to be
careful to check their dates around that time. When completing their records, some churches decided that they'd not have anything to do with all that
new fangled stuff and continued with the Julian calendar. Which is not helpful when you are loking at this stuff nearly 300 years later! You always need
to double check any dates from 1752 to say 1760. Just in case.

[Lord]

Only a rough overview:

Year Country/-ies/Areas
1582 Spain, Portugal, France, Poland, Italy, Catholic Low Countries, Luxemburg, and colonies
1584 Kingdom of Bohemia
1610 Prussia
1648 Alsace
1682 Strasbourg
1700 'Germany',[Note 8] Swiss Cantons, Protestant Low Countries, Norway, Denmark
1752 Great Britain and colonies
1753 Sweden and Finland
1873 Japan
1875 Egypt
1896 Korea
1912 China, Albania
1915 Latvia, Lithuania
1916 Bulgaria
1918 Russia, Estonia
1919 Romania, Yugoslavia[Note 9]
1923 Greece
1926 Turkey
2016 Saudi Arabia

(https://en.wikipedia.org/wiki/Gregorian_calendar)
For example: 1700 'Germany',[Note 8] Swiss Cantons, Protestant Low Countries, Norway, Denmark
This date is not generally true.
In these areas there were further different dates for the adoption of the new calendar.

[IdeasVacuum]

+1
Similarly, not all regions of China - in fact some records only go back 60 years or so.