How do you split a field from datasource SQL? Can you do this straight when you are querying the data from SQL or do you have to do this when I am exporting to excel. The reason I want to do this is when a date and time are together and it is exported to excel it messes up its format turning into a number. Please let me know which to do and provide an example ASAP. thanks!
OR I need away to set the format of the column with the format yyyy-mm-dd hh:mm. Thanks- possibly in excel.view.php file
Do I use this ->pipe(new ColumnMeta(array(
"start_datetime"=>array( 'type' => 'yyyy-mm-dd hh:mm', ), )));
If so how and where?