Query Custom field times

[John Wood]

Hi all,

We use Jira for Change Management, and I'm trying to find all changes that were ongoing between 6am and 10pm

We use two fields, RWS (requested window start) and RWE (requested window end) so i want to work out any change where any point between RWS and RWE is also between 6am-10pm

I'd even just be happy with "Where RWS is between 6-10 OR RWE is between 6-10" - that could theoretically miss some if RWS is 5am and RWE is 11pm, but they would be real edge cases.

Anyone got any idea if this is possible? I think the problem I am having is that RWE & RWS are date/time fields, so I cant separate the times only, I have to also specify dates?

Thanks