Help by adding the date column in gradebook

Help by adding the date column in gradebook

by Jhon Do -
Number of replies: 5
Greetings moodle community.

I need help to include the date column for each of the activities of my students to be able to export it as .xls

There is an option for moodle 1.9 but can not find anything for 2.1.

Someone could help me with this?
In reply to Jhon Do

Re: Help by adding the date column in gradebook

by John Samuel -

i am wondering how do you export Date in gradebook to excel ?

we have the Datetime user profile field for moodle 1.9 but when we export we only get bunch of numbers.. can you please assist me to be able to export it?

Thanks,

Sam

In reply to John Samuel

Re: Help by adding the date column in gradebook

by Marty Soupcoff -

@Sam - Check to see what format you have the dates column in Excel. If you have the dates in number format, then it will display numbers starting from 1/0/1900.

Examples: 1/0/1900 = 0, 2/12/2012 = 40951

Change the date column to date format (there are multiple you can select from) and you should be good to go.

Happy Moodle Logooodling!

In reply to Marty Soupcoff

Re: Help by adding the date column in gradebook

by John Samuel -

i believe it's a unix timestamp and i also believe that there is hack that will help you export dates as dates without converting in excel.

i just can't recall that forum

In reply to John Samuel

Re: Help by adding the date column in gradebook

by Jhon Do -

I have an option for 1.9 and is in this reference, but its in Spanish, I hope will be useful.

Someone who can implement it in 2.1?