Re: Perl OLE Time Formatting Error!?

Have you considered using
DateTime::Format::Excel ?

use DateTime::Format::Excel;    
# From Excel via class method:    
my $datetime = DateTime::Format::Excel->parse_datetime( 37680 ); 
 # OR retrieve $value->Date(<Whatever syntax works here>)
    
print $datetime->ymd('.'); # '2003.02.28'
[download]

"There are only two truly infinite things. The universe and stupidity, and I'm not too sure about the universe"- Albert Einstein

Comment on Re: Perl OLE Time Formatting Error!? Download Code

Replies are listed 'Best First'.
Re^2: Perl OLE Time Formatting Error!? by PerlingTheUK (Hermit) on Jun 01, 2005 at 09:11 UTC
Did not try this, But it was a stupid Error and one more or less for a VB group: `$value12hour = $value->Time( "hh:mm:ss" ); $value24hour = $value->Time( "HH:mm:ss" );` [download] I guess this is selfexplanatory. Cheers, PerlingTheUK	[reply] [d/l]