Solved Reports do not shot date/time in a consistent format

[George Ts]

Hello,

We recently noticed that our reports (.csv format) do not keep a consistent format for date - time across the same .csv file. Please see the attached screenshot. The first few line across all .csv files recorded in the last 3 months, show the date/time in a mm/dd/yy hh:ss format, while the last lines show as mm/dd/yy hh:mm:ss AM/PM format.

Any idea why this happens?
We are running an older version, 15.5.6354.2.

Regards,
George

 

[George Ts]

Please close this thread, it has been confirmed that the .csv file exported by 3cx includes the date/time in a consistent format.
For anyone interested, the reason behind the various formats, was MS Excel
Regards,
George

 

[YiannisH_3CX]

Glad to see the issue has been resolved and thank you for updating the thread with your solution.