I need to calculate the difference between 2 dates. I have 2 fields in a text file. I thought I had the dates in the right format.

the error is "Date::Calc::PP::Delta_Days(): Usage: Date::Calc::Delta_Days($year1,$month1,$day1,$year2,$month2,$day2)" 

file1
2013,06,21      2013,06,24
2013,06,23      2013,06,28
2013,06,08      2013,06,10
2013,06,23      2013,06,24
2013,06,13      2013,06,18
2013,06,29
2013,06,17      2013,06,19
2013,06,13      2013,06,18
2013,06,29
2013,06,06      2013,06,10
2013,06,10      2013,06,26
2013,06,23      2013,06,29
2013,06,06      2013,06,10

[download]

my script - if possible would like to fill the empty spaces with the last day of the current month date 

#!/usr/bin/perl
# 
use strict;
use warnings;
use Date::Calc qw( Delta_Days );
my $cnt = 0;

open (my $file, '<', (@ARGV)) or die $!;
while (<$file>) {
    my @dates = split '\t', $_;
    $cnt++;
#    printf "%-10s %-10s\n",
#    $dates[0], 
#    $dates[1];

my @dates1 = ();
my @dates2 = ();

push (@dates1, $dates[0]);
push (@dates2, $dates[1]);

my $diff = Delta_Days(@dates1, @dates2);
print $diff, "\n";
#printf "%-12s %-12s\n",
#@dates1, 
#@dates2;

}
close $file;

print $cnt, "\n";
exit;

[download]

Thanks so much for your help, it is a life-saver

In reply to Trouble with Dates by rruser

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.