How to query Datetime field as Date only in JQL Datecompare search query

[Mariam Mohamed]

I have query built to compare two Datetime fields, but the issue is that I need it to read the date only without the time. Please let me know if there's any way or workaround.

Here's my query (bold text represents the datetime I want to read as date only):

issueFunction in dateCompare("Project = EEE AND issuetype not in (Epic) AND \"Planned End\" >= startOfYear() AND \"Planned End\" <= now()", "Actual End > Planned End")

[Patty Land · Accepted solution]

This article provides a Groovy expression using the custom field ID plus "clearTime", which may be helpful to you: https://community.atlassian.com/t5/Jira-Core-Server-articles/How-to-find-issues-where-one-date-field-is-greater-smaller-equal/ba-p/1031391#:~:text=JQL%20does%20not%20let%20you,but%20ScriptRunner%20add%2Don%20does.&text=This%20query%20works%20fine%20when,of%20type%20date%2Dtime%20picker.&text=The%20underlying%20reason%20is%20that,hours%2Fminutes%2Fseconds).

[Mariam Mohamed]

Thank you so much Patty, this was stuck with our management reporting team for long.. Glad to have found a solution!