🚀 go-pugleaf

Hmmm...that doesn't sound right for OLE dates.  Day 0 should be 
01/01/1900, and progress forward, 1 for each full day.  So 0.75 is 6PM 
on 01/01/1900.

I'd probably use an SQL insert statement to do the insert, and represent 
the string in human-readable format, delimited by #'s.  For example, 
#Jan 23, 2014# .  I don't know if I'd try to go the route of calculating 
compared to a Java date.

When extracting the information from the db, I'd use the Access date 
functions (DateDiff and so forth) to construct the date into a string 
format.

My sincerest sympathies since you have to use Access.  One would think 
that the ODBC driver would properly change the format of the date, (or 
maybe that is "property formatted", but other ODBC hasn't given me issues.)

So long story short, don't use Date variables - use string manipulation 
to put things together in a common readable format.

Will Stranathan

Randy K. Secrist wrote:

> 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
> 
> 
> 
> 
>