#! /usr/bin/perl -w use strict; use Win32::OLE::Variant; use Win32::OLE::NLS qw/ :LOCALE :DATE /; my $v = Win32::OLE::Variant->new(VT_DATE, shift || 'Sep 3,2001'); print $v->Date( 'yyyy/MM/dd' ), "\n"; print $v->Number( {ThousandSep => '', DecimalSep => '.'}), "\n"; #### E:\david\perl>perl wov.pl "Sep 3,2001" 2001/09/03 37137.00 E:\david\perl>perl wov.pl "Jan 1,1900" 1900/01/01 2.00 E:\david\perl>perl wov.pl "Jan 2,1900" 1900/01/02 3.00 E:\david\perl>perl wov.pl "Jan 3,1900" 1900/01/03 4.00