Report is One Week Off: June 6 2026 falls in week 23 of the year | Report -> Week 22

[crmclients]

I have this same problem as here https://forum.espocrm.com/forum/bug-...datetime-field trying to figure out what is wrong

June 6, 2026 falls in week 23 of the year. - But my report has it in Week 22. The client said they didn't understand why it was off then I saw the post above. Is there a fix since 2018?

Microsoft Outlook also has it at week 23.




Also, please allow some option to display the actual date range to avoid this issue forever.



Here are the parameters



Please advise how to make it show correctly but better show dates that are more useful 1) Date Range 2) Week Of (Sunday date)

[heint]

Greetings, crmclients,

This logic is related to the DST and how the database operates with this format. You can try to change the timezone to a different value, and you will see that this "issue" will be removed.

That intentional logic is confirmed by developers, so everything is working as intended in this case.

[crmclients]

Hi @heint

If I change the time zone won't all the system time stamps, date/time formulas, workflows, be off? Everything the client and vendors view except his 1 report? Then change back every time change?

Clients in Arizona USA never change their time, I'm in CA with PST and DST, vendors on east coast also use exports of time stamped data.

It think it's more involved than settings...

[yuri]

When grouping by WEEK(datetime field), the DST is not applied.

If it's important to display a correct week for a date-time field, there's a solution. Create a read-only Date field. Set it with formula by deriving the date part from the date-time field value. Then use the Date field in the report.

[crmclients]

Ok a r/o date field on the Lead and Opp and prop should do Call and Meetings as they are starting to want more of these reports also

Pull out the Week format only then group by that instead

Thanks Yuri I will attempt this and post the findings