Can I use JQL with day of the week?

[JongBum Lee]

Dear all

I want to query the issue generated from Monday to Friday using the JQL.

Is there any way ?

[Mario Günter · Accepted solution]

Hi JongBum Lee, 

what about following jql:

created >= startOfWeek() AND created <= endOfWeek() ORDER BY created ASC

if you want to query last week you can edit it like that: 

created >= startOfWeek(-1) AND created <= endOfWeek(-1) ORDER BY created ASC

Hope this helps?

Cheers, 
Mario 

[JongBum Lee]

Thanks Mr. Mario. I can not write English very well. Sorry. I want "Create Issue Monday to Friday (except saturday and sunday)" no matter what week

[Nic Brough -Adaptavist-]

I'm afraid you'll need to find/write a JQL function to do that, or do something sneaky with a scripted field