Page 1 of 1
Suppress the Date() limitation
Posted: Sun Dec 08, 2019 3:46 pm
by 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
Re: Suppress the Date() limitation
Posted: Sun Dec 08, 2019 3:47 pm
by davido
+1
Re: Suppress the Date() limitation
Posted: Sun Dec 08, 2019 4:02 pm
by Tenaja
+1
Re: Suppress the Date() limitation
Posted: Sun Dec 08, 2019 10:15 pm
by BarryG
+1
Re: Suppress the Date() limitation
Posted: Fri Dec 13, 2019 8:54 am
by thyphoon
+1 and before 1970

Re: Suppress the Date() limitation
Posted: Fri Dec 27, 2019 6:38 am
by Seymour Clufley
+1
Re: Suppress the Date() limitation
Posted: Sun Jan 05, 2020 1:15 pm
by wayne-c
thyphoon wrote:+1 and before 1970

+1000000

Re: Suppress the Date() limitation
Posted: Thu Jun 18, 2020 5:58 am
by 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

Re: Suppress the Date() limitation
Posted: Thu Jun 18, 2020 7:28 am
by Lord
thyphoon wrote:+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.
Re: Suppress the Date() limitation
Posted: Fri Jun 19, 2020 7:38 am
by thyphoon
The Gregorian calendar is the internationally accepted civil calendar that was first adopted in 1582

Re: Suppress the Date() limitation
Posted: Fri Jun 19, 2020 7:50 am
by Lord
thyphoon wrote: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.

Re: Suppress the Date() limitation
Posted: Fri Jun 19, 2020 8:28 am
by thyphoon
Lord wrote:...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.
Re: Suppress the Date() limitation
Posted: Fri Jun 19, 2020 8:44 am
by 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.

Re: Suppress the Date() limitation
Posted: Sat Jun 20, 2020 10:47 am
by Lord
Only a rough overview:
Wikipedia wrote: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.
Re: Suppress the Date() limitation
Posted: Sat Jun 20, 2020 11:05 am
by IdeasVacuum
+1
Similarly, not all regions of China - in fact some records only go back 60 years or so.