Is there a way to change the first day of the week in reports

[David Forster]

Hi all,

I think I've just about checked every setting but looking forward to someone proving me wrong.

Is there a way to change the first day of the week in reporting? it seems to default to Sunday - Saturday.

Here in the UK, Monday - Sunday is more common

It would also be great to change the date format on the report, seems to be hard coded to mm/dd/yy again us strange people in UK use dd/mm/yy.

Cheers,

Dave.

 

[AWS2P]

Hi
perhaps you can use a custom range to schedule so you can choose from when you want report start and finish.

For date format no idea if change is possible. i've done a test on mine (in french) and date is in US format too.

 

[David Forster]

Thanks, yes could do that, customer can sometimes get a bit confused creating scheduled reports using custom ranges (ends up getting reports each week for same fixed week in history), hence was hoping they could use the built in options.

Hi
perhaps you can use a custom range to schedule so you can choose from when you want report start and finish.

For date format no idea if change is possible. i've done a test on mine (in french) and date is in US format too.

 

[AWS2P]

I'm thinking something about date format, is your PBX cloud hosted debian version?

have done a test with a demo french pbx choosing last week range and date are in french format and start on monday 29 of july

 

[David Forster]

Yes hosted debian on all our installs, I could try updating regional setting on os, just be useful to have confirmation 3cx takes its format from os before going this route. Can't imagine changing regional settings would have any effect on 'first day of week' although appreciate you didn't suggest that would fix it.

 

[AWS2P]

that's what i wanted you to advice , if you 've done pbxexpress install everywhere it's probably the reason why locales are not set as your location.
This was for me a problem for welcome email sended in english for French users, so i've done recently a change on all and now it works like a charm, process is very easy to do, i search the link to post here the way to do.

 

[AWS2P]

here is the solution, you just need to change locale file to UK
https://www.3cx.com/community/threads/welcome-email-in-french-v16-sp2.66986/#post-288930

 

[David Forster]

Thanks, don't tend to use pbxexpress but you may still be right as we do install base OS from a template which may well have incorrect settings, I will give it a go and report back, thanks

 

[AWS2P]

you're welcome