On 5 Oct 2006 10:25:37 -0700, Matimus <[EMAIL PROTECTED]> wrote: > > the date( 8/9/2006 ) in Excel file, i am getting the value as 38938.0, > > which I get when I convert date values to general format in Excel. I > > want the actual date value. How do get that? > > 38938 appears to be the date in days since 1/1/1900. I'm sure someone > can help you figure out how to convert that to a more useful value.
>>> excel_date = 38938.0 >>> python_date = datetime.date(1900, 1, 1) + datetime.timedelta(days=excel_date) >>> python_date datetime.date(2006, 8, 11) -- Cheers, Simon B [EMAIL PROTECTED] http://www.brunningonline.net/simon/blog/ -- http://mail.python.org/mailman/listinfo/python-list
