Issue Summary

• When we click in one of the columns of Time Since Chart a new page is opened with a JQL search.
• However, this JQL is returning an error because we are using this Gadget with a "Date Picker" Custom Field and it automatically adds the time "23:59" to the query.
  

This is reproducible on Data Center: yes

Steps to Reproduce

1. Create a KANBAN or SCRUM project. Let say we created project KANBAN1.
2. Create a custom field of type DatePicker. Assign this field to the project created. Let say we created custom field of type Date Picket and named it SimpleDatePicker.
3. Create 4 or 5 issue for this project. Also at time of issue creation, set this DatePicker to a date. We can set 5 consecutive dates for these new five issues.
4. Create a Dashboard for this project and add gadget Time Since Chart to the dashboard with configurations like this screenshot.

• Once we save, we should see chart with vertical bar.

• Now click on one of these blue vertical bar. It should redirect to issue search page with broken JQL. Here we find that end-date in JQL is including timestamp as well. Because of the timestamp this JQL output is broken. 

Expected Results

• Once we click on any column of Time Since Chart gadget, JQL should show results.

Actual Results

• The below exception is thrown in the atlassian-jira.log file:

2023-10-13 12:32:51,685+0000 http-nio-8080-exec-81 INFO admin 752x1263x1 wtwhxn 172.29.176.179,172.50.0.2 /issues/ [c.a.j.i.s.searchers.transformer.RelativeDateSearcherInputTransformer] Unable to parse date '2023-10-14 23:59'.
 

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available