Filter Kanban "Completion" or "Closed" Date

Question

Good morning, I would like to filter my Kanban Issues by the date an issue was placed into "Completed," "Closed," or "Cancelled". I am trying to only display and export data that started on 01 October 2023. Any ideas? Thank you,

-Justin

Tim C_i4lu7p · Answer

Hi @Justin Anderson Assuming your workflows are properly setting the "resolution" field when ticket transitions to "completed/closed/cancelled" status ... then you can use "resolved" to query against dates ... If you're only after those resolved on 01-Oct ... resolved >= "2023-10-01" and resolved < "2023-10-02" If you're only after those created on 01-Oct ... created >= "2023-10-01" and created < "2023-10-02" If you want those created and closed on 01-Oct ... created >= "2023-10-01" and created < "2023-10-02" and resolved >= "2023-10-01" and resolved < "2023-10-02" I hope this helps? Thanks TC.