@@ -, +, @@ --- C4/Reports/Guided.pm | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) --- a/C4/Reports/Guided.pm +++ a/C4/Reports/Guided.pm @@ -588,7 +588,10 @@ sub execute_query { my $dbh = C4::Context->dbh; - $dbh->do( 'UPDATE saved_sql SET last_run = NOW() WHERE id = ?', undef, $report_id ) if $report_id; + if ($report_id) { + my $now = output_pref( { dt => dt_from_string(), dateformat => 'iso' } ); + $dbh->do( 'UPDATE saved_sql SET last_run = ? WHERE id = ?', undef, $now, $report_id ); + } my $sth = $dbh->prepare($sql); eval { --