🚀 go-pugleaf

Help!

Does anyone know how to get the number of exact days since or before a
specific time period?  If you think you can help, let me describe what I am
doing below...

I am inserting rows into an access database.  One of the columns I am adding
is a date field.  Normally using Oracle or DB2, I can instantiate a
java.util.Date, and insert the variable directly in the insert statement,
and the correct date gets inserted into the database.

However, in this case, the people I am doing a program for are set on using
MS Access.  *Sigh*.  The driver throws an exception if I use a
java.util.Date, and if I use a java.sql.Date it successfully inserts the
field into the database, but the wrong date is added to the row.  So, after
experimenation, i noticed that to get the correct date into the database,
the SQL insert statment must have the date fields is just really a regular
integer that looks like this:

0 being December 30 1899
1 being December 31 1899
2 being Jan 01, 1900
3 being Jan 02, 1900 etc.

25569 being Jan 01, 1970

Since java tracks time in miliseconds from Jan 01 1970 - 12:00 AM being
around 2703600000 miliseconds, i started to do  this the hard way - to get
the number of days since 01/01/1900 from the number of miliseconds since
1970 - writing all kinds of methods to divide and get the miliseconds right.

So far this work around seems to work for 1900 to 2100 years, but if I go
back far in time, say to 1700 it starts getting off by a few days.  For all
i know it has to do with leap years, and the such.  Basically I don't want
to write a whole date class just to get the number of days... does anyone
have solutions that could save me a lot of time and hassle?  I'd really
appreciate it....

Randy Secrist