PyTime Object and Application Crashing

R

Ryan Scott

Hi,

When I run a query against an access database and the default date for
my date/time field is 12/30/1899 the application crashes. Changing this
to a different date like 03/03/2003 works.
The output of the query when returned as a list is as follows:

[571, u'DE8', <PyTime:10/2/2003 12:00:00 AM>, <PyTime:12/30/1899 1:05:51
PM>, 0.
079999998211860657, u'1 - Litter in sample', u'', False, 10.0, 0.0]

When I try to print item 4 (list[3]) of the list, the application stops
and I get a "Send Error Report" in Windows XP.

I am using python 2.3.3 and the win32all-163 extension.

Thanks
Ryan
 
D

Dennis Lee Bieber

Hi,

When I run a query against an access database and the default date for
my date/time field is 12/30/1899 the application crashes. Changing this

From the Access help file:
access>
access> DATE
access> Returns the serial number of a particular date.
access>
access> Syntax
access>
access> DATE(year,month,day)
access>
access> Year is a number from 1900 to 9999.
access>
access> Month is a number from 1 to 12 that represents the month of
the year.
access>
access> Day is a number from 1 to 31 that represents the day of the
month.

Take a close look at the valid range for Year.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,769
Messages
2,569,578
Members
45,052
Latest member
LucyCarper

Latest Threads

Top