nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fixed values for startofmonth/endofmonth

Thomas Fredrik Bergmann

Hiya!

I'm doing a query with created >= "2018-10-01 00:00" AND created <= "2018-1-01 00:00", that I potentially will manually change every month.

How do I instead use startOfMonth() and endOfMonth() if I i.e. want to limit the results to August month? startOfMonth(8) I guess will start from the 8. month from now, as I guess it's relative values?

Accepted answers

Alexey Matveev

Hello,

You can get 01 August by this one

startOfYear(212d)

All comments

Alexey Matveev

Hello,

You can get 01 August by this one

startOfYear(212d)

Vinu_pahcqf

Hi @Thomas Fredrik Bergmann

If calculating the number of days might be difficult for you. You can mention the month based on your current month.

For Eg: If I say my present month is September and I want the issues from august, you can query the function to be startOfMonth(-1) which denotes the previous month.

The calculation is always from the present month, which means if I have startOfMonth(-2), it means October if my present month in December and startOfMonth(2) would mean the seond month down the line.

Thomas Fredrik Bergmann

Thanks for the answers. However, I need it of course to be a fixed month. I can't have it tomorrow be a different result, so I have to get away from relative values all together. It would seem that others need this too, so there probably is another way of doing it, if startOfMonth() only takes relative values.

Alexey Matveev

If you use startOfYear(212d) it will be always August first of the current year.

Thomas Fredrik Bergmann

Ah, okay got ya, so I missed the d behind the integer. In that syntax, maybe startOfYear(8m) maybe works?

Thomas Fredrik Bergmann

Oh, it didn't. I guess it's not 212d in leap years?

Alexey Matveev

m means minutes. There is no shortcut for months.

212d gives you August 1 in the current year. If it does not give you August 1 in the next year (leap year), then you should change the filter. But you will do it only once in 4 years.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql

date