Hi Atlassian Community:
I'm looking to create a JQL query in JIRA to report tickets/issues based on:
I currently have the following:
project = "xxx" and created > startOfWeek(-2d) and created < endofweek(5d)
Please advise is this is correct.
Thanks.
That looks correct to me, and I ran a couple of tests on my system that corroborate it.
Hi Payne
Thank you for your response. Is there anyway I can capture the date/timestamp in the startofweek and endofweek function?
I understand that the default is :
startOfWeek() starts Sunday 00:00 h
endOfweek() is Saturday just before Midnight
I guess it's just because my date criteria is defined as Friday 12:01 am to Thursday midnight.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Best I can tell (maybe someone can chime in to definitively answer) is that adding/subtracting days maintains the time; in other words, startOfWeek() is Sunday at 00:00, startOfWeek(-1d) is Saturday at 00:00, startOfWeek(-2d) is Friday at 00:00, etc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, I mistakenly omitted the 'd' in my examples. I have edited to correct.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.