How can I rank issues by due date AND time on the Kanban board?

[Yifan]

For context, I’ve been trying to rank issues on the Kanban board based on their due date and time. Since it's not possible to add time to the default due date field, I created a custom field using the Date Time Picker and set up a filter to order the board with:
project = AIO ORDER BY cf[10009] ASC.

However, I've run into a few challenges. On the timeline, Jira defaults to using the start date and due date, and when I move an issue, it doesn’t automatically adjust to reflect changes in my custom due date with time field.

Even with automation, I worry that if I try to synchronize the date field each time I move an issue, I’ll quickly exhaust my automation limit. Is there another way to rank issues based on my original intention to sort by due date with a time option, or a workaround to help with this?

Any advice would be greatly appreciated!

Yifan

[Trudy Claspill]

Hello @Yifan 

Welcome to the Atlassian community.

Can you tell us more about your use case for using due date and due time for ranking issues?

Do you really have an expectation that the work items will be completed not just by the specified date but also by the specified time?

Do you need to specify both the hour and minutes for the time?

How often do you update the time portion in your custom field?

If you automated the synchronization of the Due Date to your custom field, would you also be changing the time value in your custom field?

Do the users of this data work in multiple time zones?

If you must rank by due date and time, my initial thought is to use the native Due Date field and a custom number field for just the time portion. If your users are in multiple time zones this would be difficult to manage, but so far it is the only solution I've found