Database

Hi there,

I have the Datetime profile field and eachtime i export the grades from gradebook to excel, this field shows bunch of numbers that don't make sence . how did you guys get it to work?

Thank you

It doesn't matter where you put it in the script as long as it is within the class definition as a method of the class. Here's an illustration of the function added at the end of the class:

class data_field_date extends data_field_base {

    var $type = 'date';

    var $day   = 0;
    var $month = 0;
    var $year  = 0;

    function display_add_field($recordid=0) {
        ...
    }

    //Enable the following three functions once core API issues have been addressed.
    function display_search_field($value=0) {
        ...
    }

    function generate_sql($tablealias, $value) {
        ...
    }

    function parse_search_field() {
        ...
    }

    function update_content($recordid, $value, $name='') {
        ...
    }

    function display_browse_field($recordid, $template) {
        ...
    }

    function get_sort_sql($fieldname) {
        ...
    }

    function export_text_value($record) {
        if ($this->text_export_supported()) {
            return userdate($record->content, get_string('strftimedate'), 0);
        }
    }

}