date format issues

Scheduler Javascript
#1

using your sample 05_loading_mysql, converted the events.php from mysql to mssql , worked fine but the date format is …

<start_date>

</start_date>
<end_date>

</end_date>

The static events.xml file works on the page and looks like this,

What file, php or js or other file controls the output date format. I’ve used scheduler.config.xml_date = “%Y-%m-%d %H:%i:%s” on the html page ; but this controls the reading of the xml data into scheduler and not the php xml output.

thanks for your help

#2

By default connector show the same value which database have returned
You can change code in events.php as

[code]$scheduler = new schedulerConnector($res);
function format_date($data){
$start = $data->get_value(“start_date”);

$start = some_custom_format_logic($start); //any formatting logic here

$data->set_value("start_date", $start);

}
$scheduler->event->attach(“beforeRender”, format_date);
…[/code]

Also, instead of render_table you can use render_sql and embed data formatting commands directly in sql.

#3

Thanks Great that works!