JQL Search monthwise

[Manoj]

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

[Barnali Putatunda · Accepted solution]

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]

Hello Barnali, 

Thank you for your kind response. 

It's helpful indeed. 

Thanks, 

M

[Jakub Hanak]

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]

Thank you Jakub. For your swift response. 

Thanks Again. 

Regards, 

Manoj