startOfWeek() only returns issues newer than Wednesday?

Question

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?

Steve Rosenberry · Answer

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...

Jack Brickey · Answer

@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