Fetch issues which worklog added within time frame with jql c#

[Harsha Khapre]

I am trying to fetch all issues which have newly worklog added. some how my api is working if only send date with jql query but if i provide time as well it is not working and bad request error occurred.

Working:
api/3/search?jql=worklogDate >= '2023-12-22' AND worklogDate <= '2023-12-25' AND project = PROD

Not working:

api/3/search?jql=worklogDate >= '2023-12-22 10:23:12' AND worklogDate <= '2023-12-25 05:38:12' AND project = PROD

[Sunny Ape]

Hello @Harsha Khapre 

You would have gotten an error message back such as:

"Date value '2023-12-22 10:23:12' for field 'worklogDate' is invalid. Valid formats include: 'YYYY/MM/DD', 'YYYY-MM-DD', or a period format e.g. '-5d', '4w 2d'."

... which gives the reason why it's not working; the worklogDate field doesn't support a time, only a day, so you cannot use JQL to find worklogs at a more granular level than on a particular day.

If you Google 'jira worklogdate time bug' the first result is the bug that's already logged for this.

[Craig Nodwell]

Hi @Harsha Khapre welcome to the community.  What is the time format in your system?  

[Harsha Khapre]

format :     yyyy-MM-dd HH:MM:SS 

timezone: est