Hi Community,
Need a query that filters based on the day of the week. I am basically looking for the ticket that were created on Thursdays and Fridays only since the beginning of this year.
I have this query but it is not showing me the results, and I am not sure why
created >= "2024-01-01" AND created < now()
AND ( (created >= startOfWeek(3d) AND created < startOfWeek(4d)) OR (created >= startOfWeek(4d) AND created < startOfWeek(5d)) )
Hi, function startOfWeek gives you date on Monday and when you pass f.e. 3d parameter it adds to this date 3 days. So query you just showed is looking for issues from this week. I don't think that there is a date function in jql which can resolve your problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.