Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL Search monthwise

Manoj
Contributor
January 15, 2019

Hi There,

Could you please help me on query below.

i have to search all the candidates joined in the of month of dec-18 in my project. not able to fit the query correctly [i know this is very basic but still seeking right help]

Appreciate your quick help.

 

Thanks!

M

2 answers

1 accepted

1 vote
Answer accepted
Barnali Putatunda January 15, 2019

Hi,

You can use the below as a generic filter which will always give you the data of last month.
created >= startOfMonth(-1) AND created < startOfMonth()
Replace created with the date field on which you want to filter out.

Manoj
Contributor
January 17, 2019

Hello Barnali, 

Thank you for your kind response. 

It's helpful indeed. 

 

Thanks, 

M

0 votes
Jakub Hanak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 15, 2019

Hello @Manoj,

what do you mean by candidates joined? 

You can try basic query like 

"startdate" >= 2018-12-01 AND startdate <= 2018-12-31

Instead of "strartdate" insert the field that you need to filter. 

Have a good day,

Jakub 

Manoj
Contributor
January 17, 2019

Thank you Jakub. For your swift response. 

Thanks Again. 

Regards, 

Manoj

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, mindful member, mindful member badge, atlassian community, community kudos, community giveaway, atlassian swag, community values, empathy and kindness, badge challenge, atlassian learning, community engagement, swag giveaway

Earn a Badge, Win a Prize 🎁

Earning the Mindful Member badge proves you know how to lead with kindness, plus it enters you into a giveaway for exclusive Atlassian swag. Take the quiz, grab the badge, and comment on our announcement article to spread the good vibes!

Start here
AUG Leaders

Atlassian Community Events