It seems that Spreadsheet::ParseExcel isn't working properly with dates, the Excel spreadsheet has 10/01/2006, but when parsed by perl it becomes 38991. But if the dates where entered in as Oct 1 2006, this works fine. I have tried formattting excel, but I get the same results. I am using
my $eff_date = uc(trim($ws->{Cells}[$row][2]->{Val}));
to get the values from excel, I have also tried {_Value}, but only get the 2 digit year, which will not work.
any help is great, thx
Code tags added by GrandFather