Inconsistency of datetime format in CSV report

[ACL]

Hi Experts,

We have noticed an inconsistency in the date/time format within our CSV report. While the 3CX UI displays the date/time correctly, the format in the exported CSV report appears differently. Please find the attached files for reference. We need the datetime format in CSV to be displayed as DD-MM-YYYY 24-hour format.

Is there a way to ensure that the CSV report follows the same date/time format as shown in the 3CX UI?

Troubleshooting Attempts
We have already tried the following solutions, but they did not resolve the issue:
https://www.3cx.com/community/threads/stuck-with-usa-format-on-time-and-date.125988/

Solved Post in thread 'Inconsistency in the reporting'

Dec 9, 2021

So it's not the inconsistncy between title line and column, you want the date/time format to show us dd/mm/yyyy HH:mm:ss, right?

If this is the question, the the date/time format is controlled by the OS Locale.

Judging by what you have now appearing, I am guessing you have the US locale.

What you need to do to change the Locale on Debian is:

1. Important! Make a backup and download it to your desktop. It's aprecautionary measure in case you need to re-install
2. Log on via SSH and run:
   

   sudo dpkg-reconfigure locales

3. in the list leave the existing selected options...

• NickD_3CX

Any insights or suggestions would be greatly appreciated. Thank you!

 

[NicholasP_3CX]

The date format in the CSV is in the YYYY/MM/DD format to get rid of any confusion between the different time formats.

In the web client interface, you would see the reports in your own selected time format, based on the language settings you have selected.

But as the CSV can be emailed to various persons, it is presented in the logical format of YYYY/MM/DD

 

[ACL]

Noted on that. Can I have the report on this format (DD-MM-YYYY 24-hour) too?

 

[NicholasP_3CX]

Yes, just open it in Excel and change the date format.

 

[ACL]

Unfortunately, it cannot be done so after I adjusting the date format, could you please guide us on this?

 

[NicholasP_3CX]

You would do this in Excel. Im using Google shhets here, but the concept is the same



Once the format is selected, it will show the proper times. The system will always produce the report in the default date format of YYYY-MM-DD. You would have to do this in your Excel.

We will have to wait for our new reporting engine to see with the external integrations if you would be able to customise the date from the source reports.

 

[ACL]

Okay, looking forward for the new reporting engine, thanks!

 

[ACL]

Hi Nicholas,

Unfortunately, Excel unable to do such formatting.