I wish did fix the issue. The best you can do in Jira 4.1.1 is to get all issues resolved in the last 7 days from now: resolutiondate >= "-7d" Or create a filter for each day of the week. For example filter 'Issues resolved in a week (Wednesday)" will be resolutiondate >= "-3d". And filter 'Issues resolved in a week (Friday)" will be resolutiondate >= "-5d"
Check if current time is between 5pm on friday and 9am on monday
I think the issue was by ths following , Here's a slightly "magical" way to compute the value that doesn't depend on any particular server settings such as datefirst. It's probably not immediately obvious how it works:
WHERE DOC_DATE = dateadd(day,datediff(day,'20150316',getdate()),
CASE WHEN DATEPART(weekday,getdate()) = DATEPART(weekday,'20150330')
ELSE '20150315' END)