my $rows = $dbh->selectall_hashref(...);
...
foreach my $hashref (@$rows)
{
    $hashref->{'g_afsluttet'}
        = con_date($hashref->{'g_afsluttet'});
}
...
$tmpl->param(LOOP => $rows);