Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can someone please explain the behaviour of 'not status changed after -2d' and implicit times?

James Birch March 1, 2019

Hi,

It seems rather difficult to find information on the implicit time syntax in JQL. Can anyone point me to the help documentation on this? I can't find it. Google tends to come up with community posts rather than the official help documentation.

(I'm English so using UK date format dd/MM/yyyy)

Anyway assuming the current time is 01/03/2019 15:11:

not status changed after -2d

will find statuses that haven't changed since 28/02/2019 00:00:00 (~ a day and a half ago)

Not 27/03/2019 15:11 or 27/02/2019 00:00:00

Whole time units are used as used in the query (in this case days). The time period is inclusive of the current partial period. 

Equivalents to the above:

endOfday(-2)

startOfDay(-1)

Other examples (hours):

not status changed after -48h

will find statuses that haven't changed since 27/02/2019 16:00:00 

not status changed after -49h

will find statuses that haven't changed since 27/02/2019 15:00:00

Both include current partial hour and work in complete hours.

Can someone confirm my understanding is correct?

Many thanks,

James

0 answers

Suggest an answer

Log in or Sign up to answer