Greetings happy moodlers,
Qucik question! i am using a new profile field 'Date Format' here http://tracker.moodle.org/browse/MDL-24806?focusedCommentId=143330#comment-143330 but the configurable reports block doesn't show the date as a date. it just shows bunch of numbers. can you please assist on how to make your block show it as date and export it as date.
Thanks
If you're writing the SQL query yourself (on the SQL tab) you can use DATE_FORMAT(fieldname, '%M %d, %Y') to display it like, "February 8, 2012"
Thank you Kimber but what if i want to use a user-report instead ?
when i pick user profile field = date it shows bunch of numbers...
Example i set the permission to see the report to; profile field Date = 01/01/2010 and it doesn't work because it doesn't read the date field as a date field.
I hope Juan can assist here
Thank you
Sorry, I'm afraid I can't help you there. I only know how to format a date using MySQL. Hopefully someone else will chime in.
Hi John,
currently my plugin doesn't support this type of new profile fields
I think that if you modify this file:
And add something like:
if($p->datatype == 'datetime'){
$p->data = userdate($p->data)
}
It will work
Hi Juan,
it worked beautifully nice but it's showing me '%Y/%m/%d' and %Hour
how do i get it to show just '%Y/%m/%d'?
Thank you
nevermind i found this one
Where did you find it? I'm looking to change the same thing?