×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On Thu, Aug 17, 2023 at 4:14 AM Alan Campin <alan0307d@xxxxxxxxx> wrote:
Then just write a quick and dirty program to write dates
for 20 years or so.
In my opinion, you might as well do a lot more. I like to do 400
years, specifically 1900 through 2299, because that's the length of a
complete cycle in the Gregorian calendar (146,097 days). I like to
start at 1900 because that's when Excel dates start.
I think a decent case could be made for building a table of only 100
years (36,525 days, assuming the year 2000 is included), so that
formats involving 2-digit years don't repeat. I don't see much value
in anything smaller than that. If you specifically want dates that are
too far in the past or too far in the future to be considered invalid,
test against actual cutoff dates instead of relying on being missing
from the table. You'll probably want to fine-tune the cutoff dates
depending on the application anyway. (20 years wouldn't be enough to
cover people's birthdates, or home mortgage end dates, to take a
couple of obvious examples.)
John Y.
As an Amazon Associate we earn from qualifying purchases.