On 10/5/06, Simon Brunning <[EMAIL PROTECTED]> wrote: > 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)
Err, that's the wrong answer, isn't it? Perhaps it shoud be datetime.date(1900, 1, 29)? -- Cheers, Simon B [EMAIL PROTECTED] http://www.brunningonline.net/simon/blog/ -- http://mail.python.org/mailman/listinfo/python-list