Trying to search defects based on a certain date

Question

I am trying to filter defects using a JQL on a on-prem JIRA, like project = AND issuetype = Bug AND status not in (Done, Closed) AND created <= 2020-07-23 ORDER BY labels ASC, key ASC, priority DESC, updated DESC But it is not bringing in the defects created on the date 2020-07-23. Also the date with or without any type of quotes is working the same. Looks like they are optional. Some where I read that if I use, it would work as expected project = AND issuetype = Bug AND status not in (Done, Closed) AND created < 2020-07-24 ORDER BY labels ASC, key ASC, priority DESC, updated DESC Actually, it is bringing defects, as expected. Why the Query is not working as expected.

Martin Bayer _MoroSystems_ s_r_o__ · Answer

yeah you have to use this value...my answer was I would use "2020-07-24 00:00" because I am programmer too and implementation should be as clean as possible for other programmers. Everyone will understand that condition X < "2020-07-24 00:00" will match only X which is 2020-07-23 with any time part and all dates below

NVDV Tester · Answer

Logically, I can understand what you mean.

But programmatically, I need to retrieve the defects created on the date of  2020-07-23. But by using '2020-07-23 00:00', I am still not getting the defects created on July 23rd. Only thing which is working is using '2020-07-24'.

Obviously, I am missing some thing.

Martin Bayer _MoroSystems_ s_r_o__ · Answer

your original condition looks like

created <= 2020-07-23

it is evaluated like

created <= "2020-07-23 00:00"

and it means your issue would need to be created at 00:00 on 23rd july to match the condition

First minute of a new day is 00:00 and last minute is 23:59.