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