date format issues

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




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

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);

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

Thanks Great that works!