How to make StartOfWeek and EndOfWeek use MON-SUN instead of SUN-SAT

Question

I'm trying to retrieve the issues created last week using the following JQL clause

created >= startOfWeek(-1w) AND created <= endOfWeek(-1w)

However, it still returns issues created on Sunday two weeks ago, so it is effectively considering weeks going from SUN to SAT.

The system configuration has the option "Use ISO8601 standard in Date Picker" enabled, but this does not affect the StartOfWeek/EndofWeek functions.

May this issue be due to the fact default language is set to English US?

Timmo_win99a · Answer

I too am astonished that Sunday is the "default" value (implying it can be altered from its default), and yet it cannot be altered?  There's a better word for when something has a value and it cannot be changed: "hard coded".

The proposed solution is very particular to the problem as stated, but really, this issue pervades the entire UI; calendar pickers etc.

Just curious, how is the start of week determined?  From locale, or simply hard-coded?

Andrew Kopp_xndeqs · Answer

Even the proposed solution doesnt work for the purpose of reporting.

Looking to get a view of last weeks tickets - Monday to Sunday - is impossible using startofWeek and endOfWeek in a dashboard view- as I would now need to amend this each day to ensure it pulls the right data.

It is insane to me, how this is a problem. ISO standards exist for a reason.

Andy Rusnak · Answer

Hi Pablo,

No problem, happy to provide the answer here!

In terms of your question, this isn't a workaround solution or a hack, the design of this function is to provide the maximum amount of flexibility when using these JQL functions.  While it would be possible to create multiple startOfWeek and endOfWeek functions with different default dates, that would lead to a lot of different function name that could be used within JQL leading to potential confusion on which ones to use at what times.

The design allowing the configurability using the modifiers as a mentioned allows for a single function to be used (which is easier to remember when writing statements) while allowing maximum customization.  Some teams may start their weeks on Tuesday or Wednesday for example, this allows for that without having to create individualized functions for each potential start of week or end of week.

If you would like to have the default Sunday - Saturday dates to be re-aligned to Monday - Sunday, you can submit a Suggestion to our Product team.  If there is a lot of user interest in make this shift it may be something our Product team is able to implement in a future release Jira.

Does that help to clarify why the functionality is currently designed the way it is?  If not I would be happy to discuss further.

Best,

Andy