startOfWeek() only returns issues newer than Wednesday?

Steve Rosenberry September 2, 2017

I'm running this query on a Satuday:

      created >= startOfWeek() ORDER BY created ASC

but the results only return issues from Wednesday on.  There are definitely issues created every day from Sunday on.

 

The Jira settings:

    Default language is "English (United States)".

    Default user time zone is "(GMT-05:00) New York"

 

My computer clock is correct and set for on EDT.

 

I must be missing a setting somewhere, but what?

1 answer

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 2, 2017

@Steve Rosenberry, that is odd. your JQL works in my Cloud instance. I guess you know there are issue created prior to Wednesday.

so what about the following?

createdDate >= startOfWeek() ORDER BY created ASC

created > startofday(-5d) ORDER BY created ASC

Steve Rosenberry September 2, 2017

Thanks, Jack -- but never mind. 

The last week of August 2017 starts on the 27th just like the query results are telling me, but I was validating the results looking at the last week of September 2017 on the calander which starts on the 24th.  Doh!

Know of any good remedial calander reading courses?  :)

It would be nice to delete this noise from the forum (and erase my public embarrassment along with it!), but I can't find a way to do so...

Suggest an answer

Log in or Sign up to answer