It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How do i set the first day of week so that startofweek() returns Monday instead of Sunday?

Server and Local computer both have same correct locale and have Monday as first day of week.

Using JIRA 5.2.1

5 answers

1 accepted

1 vote
Answer accepted

Australia locale appears set as Sunday first day.

To override, need to set JVM parameters on Jira service to language and country that is set for Monday e.g. Germany

-Duser.language=de

-Duser.country=DE

Make sure there are no spaces after the parameters.

Stress on that last line "Make sure there are no spaces after the parameters." ;)

Dave C Atlassian Team Feb 19, 2016

To add to this, it depends on the Java locale that is configured - by default Java picks up the locale of the operating system, and subsequently JIRA picks that up. If we take a look at http://docs.oracle.com/javase/8/docs/api/java/time/temporal/WeekFields.html, it shows us:

  • ISO-8601 starts on Monday.
  • Everything else starts on Sunday.

I haven't been able to find a definitive list of which locales are ISO-8601 - it appears Germany is one. smile

Try endOfWeek(-5d) or endOfWeek(-6d)

Please go through this ticket, this includes steps to change the start day of the week to Monday.

https://jira.atlassian.com/browse/JRA-9048

NOTE: Please test this activity on our test environment and make sure you backup the files before make any changes

My files are a bit different to what is referenced in JRA-9048, so perhaps i need to remove the '-1' ???

the macros.vm has $firstDay = $currentCalendar.firstDayOfWeek - 1

the datepicker2.jsp has firstDay : <%= Calendar.getInstance(locale).getFirstDayOfWeek()-1 %

All you need to do is -

    • Go to <install-jira>/atlassian-jira/webapps/includes/lib/calendar.
    • Open the Calendar.js file.
    • Look for the line -
      this.firstDayOfWeek = typeof firstDayOfWeek == "number" ? firstDayOfWeek : Calendar._FD; // 0 for Sunday, 1 for Monday, etc.
    • Remoe the above line and add the below line instead -
this.firstDayOfWeek = 1; 

Restart your JIRA and check whether you can see the start date ofy of the week set to Monday. This worked for me!

This has changed the issue due date picker so it now shows Mon-Sun correctly, but the startofweek() function is still set to Sunday

hmm query for Due = StartOfWeek() still returns issue with due date on Sunday

I agree with Mizan.  If you want the current week to be Mon-Sun, use "startOfWeek(1d), endOfWeek(1d)".  If you want the previous week to be Mon-Sun, use "(startOfWeek(-6d), endOfWeek(-6d))", and so on.  smile  Easy!

Hi @Rebecca B. Weis  could you please suggest what should I write in query to view the list of Jira tasks which have been updated on just a Day ago but it should not show the results on monday if the ticket was updated on friday. That is i need to avoid weekends.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

303 views 1 3
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you