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?
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
@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.
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
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?
i don't understand it sorry