Creation Time Query

[Nuno Pimenta (ADM)]

Hello Community, 

I was trying to find the best way to be able to query tickets created after a specific hour,

eg. Tickets created in last month after 17h

anyone have any tips about the best approach to have something?

thank you in advance

[Jack Brickey · Accepted solution]

Hi @Nuno Pimenta (ADM) , can you better explain your example? What does "in last month after 17h " mean exactly?

in the meantime let's say I wanted to find issues created after 7am today, for which I could use the following JQL...

created > startofday(7h)

[Nuno Pimenta (ADM)]

Thanks Jack, 

i already try the one for the current day and do the trick,

but we would like to know if there is a way to query for last month or a date range instead. Like to find issues created after 7am all days in the last month

[Jack Brickey]

You cannot do that with native JQL. Look to add-ons, e.g. powerscripts or scriptrunner or others.

[Nuno Pimenta (ADM)]

Thank you @Jack Brickey  !