Change CSV Call detail Date Time format

Hi BP,

Is possible to change this format on the Call Detail agent on the start_time to have this follow format

MM/DD/YY?

Please let us know as actually we have a customer complaining as on the CSV appears on this format: MM/D/YY the 1 digit day only appears as “1” and we need to be as "01

This is not possible with a csv file. If you need to format certain date/time values, please look at using a jrxml file instead.

@claudia.meiners , maybe share template of the report you want changed and someone can help edit it for you, its not a big tasks to do

When using BPXML, DATE_FORMAT() function can be used.

E.g. SELECT DATE_FORMAT(start_time,"%Y/%m/%d") as mydate FROM agent_performance