Solved

Perl check dates

Posted on 2011-03-02
2
388 Views
Last Modified: 2012-06-21
I have a list of dates in the following format:

20061107
20100226
20110301
20110220
20100301
20061023
20110214
20090219
20110226
20110223

How can I do a check to see what dates are older than 90 days?

Thanks,
0
Comment
Question by:bt707
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 26

Accepted Solution

by:
wilcoxon earned 500 total points
ID: 35020293
This should do it...
#!/usr/local/bin/perl

use strict;
use warnings;
use Date::Calc qw(:all);

my @today = Today();

# to read from STDIN, change <DATA> to <>
while (<DATA>) {
    chomp;
    die "invalid date: $_"
        unless (m{^(\d{4})(\d\d)(\d\d)$} and check_date($1, $2, $3));
    my @date = ($1, $2, $3);
    if (Delta_Days(@date, @today) > 90) {
        print $_, "\n";
    }
}
__DATA__
20061107
20100226
20110301
20110220
20100301
20061023
20110214
20090219
20110226
20110223

Open in new window

0
 

Author Closing Comment

by:bt707
ID: 35020505
Thanks wilcoxon !!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Email validation in proper way is  very important validation required in any web pages. This code is self explainable except that Regular Expression which I used for pattern matching. I originally published as a thread on my website : http://www…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Six Sigma Control Plans

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question