Hello Jose,
I am not sure whether or not there is an option to display dates in ISO 8601 format in the Quiz report. Maybe someone else can answer you.
In case this option is not available, you can modify the Moodle PHP code on the server side or add JavaScript on the client side. It is this last solution that I propose here which consists in putting the following code in Site administration / Appearance
/ Additional HTML / Before BODY is closed:
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js">
</script>
<script>
// Change date to ISO 8601 format in the Quiz report page
if ($("body").is("#page-mod-quiz-report")) {
$("td.cell.c5").each(function(){
var isdate = ( $(this).text() != "" ) && ( $(this).text() != "-" );
if (isdate) {
var d = new Date($(this).text());
var time = $(this).text().slice(-8);
var dstring = d.getFullYear() + '-' + ('0' + (d.getMonth()+1)).slice(-2) + '-' + ('0' + d.getDate()).slice(-2) + ' ' + time;
$(this).text(dstring);
}
});
$("td.cell.c6").each(function(){
var isdate = ( $(this).text() != "" ) && ( $(this).text() != "-" );
if (isdate) {
var d = new Date($(this).text());
var time = $(this).text().slice(-8);
var dstring = d.getFullYear() + '-' + ('0' + (d.getMonth()+1)).slice(-2) + '-' + ('0' + d.getDate()).slice(-2) + ' ' + time;
$(this).text(dstring);
}
});
}
</script>
You will get something like this:
Of course, the 12 hour format could also be changed to the 24 hour format. The above script modifies the format of the dates only on the screen. If you download the table in Excel format, you can easily change the date format using Excel's cell formatting.