use strict;
use warnings;

use POSIX     qw( strftime );
use Text::CSV qw( );
use Tie::File qw( );

use constant INHOUSE =>"Open House Information";

{
   my $today = strftime('%Y/%m/%d', localtime());

   tie(my @db, 'Tie::File', 'dbase1.exm')
      or die("Unable to open database: $!\n");

   my $csv = Text::CSV->new();

   @db = grep {
      $csv->parse($line)
         or die("Unable to parse \"$line\"\n");

      my @fields = $csv->fields();
      my ($status, $date) = $fields[22, 23];

      # Convert date to sortable format.
      my ($m, $d, $y) = split(/\//, $date);
      $date = "20$y/$m/$d";

      $status ne INHOUSE || $date >= $today
   } @db;

   untie @db;
}