3CX Report Time Format - MM/DD/YYYY instead of DD/MM/YYYY

[Sumit Bharti]

Hi All,

I am having issue with the reports I am getting is reflecting the date in MM/DD/YYYY format. However, I want to see the date format in DD/MM/YYYY.

As per 3CX. The issue here is that I did not choose the correct OS regional settings when before installing the 3CX Phone system.

PBX is using default OS settings for that and I would have to look into the locale configuration on Linux OS and change it from there.

But they have not advised me any command or anything how this can be changed or fixed. Can someone help me to advise?
If there any command which I need to run on my Linux debian system which is hosted on the Azure Platform.

I have the correct regional time settings on the 3CX Management console.

Thanks

 

[Sumit Bharti]

One more thing, when i do a locale command it only shows this to me

$ locale
LANG=
LANGUAGE=
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

 

[Alphabetic]

Hi

try looking at this thread - Please ensure you have a full system backup.

https://www.3cx.com/community/threads/reports-in-mm-dd-yyyy-am-pm-format.74946/#post-338534

 

[Sumit Bharti]

In my case there is nothing in the locale file. Please see the screenshot.

 

[Alphabetic]

Try using cd to browser to that folder and then ls to show whats in there.

I think I remember when I straight up tried to go to the location it opened as blank.

 

[Sumit Bharti]

Tried this but same. I can't see anything in the file. This is surprising.

 

[Grant Moxom]

Try modifying your LC_ALL to whatever matches your region (assuming your region is in the format you want). Eg set it to LC_ALL="en_AU.UTF-8" and you should be golden

 

[Sumit Bharti]

I could not find any file with the name of LC_ALL

 

[Grant Moxom]

I could not find any file with the name of LC_ALL

You posted your locale file and lc_all is at the bottom. Instead of LC_ALL=
you should change it to your region - such as LC_ALL="en_AU.UTF-8"