if issue matches JQL doesnt work with start of day(-7d)

[rahul sharma]

Im looking for a way to check with automation if the target start matches 7 days from now. If so i would like to flag the Userstory.

It al works when i use the start of day without the -7 days. like below

"Target start" <= startOfDay()

But when used with the -7d it doesn't work. I have used multiple options like -7 or -1M

Anyone that can help me with this?

[Valerie Knapp]

Hi @rahul sharma , welcome to the Atlassian Community and thanks for your post.

If you are looking for dates in the future, you shouldn't use a negative number.

If you want 7 days from now, you would need to write something like this

"planned start[time stamp]" >= 7d

I would anyway verify this first in the Filter section / Search work items section to make sure you are retrieving the correct work items you would like to flag.

I just recorded a short Loom to show you how I got this JQL https://www.loom.com/share/f2c2c0309b4543f9b06afa0164f9f709?sid=8cc5d7c6-320b-4dc5-87f2-9e0f511e0993 

Please have a look and see if this helps you.

Best wishes

[rahul sharma]

sorry! i have been writing the text all wrong what i meant was 7 days from now(). I meant the timestamp of today. so i would like to go back in history. I did try the JQL in the issues tab but when i use it in the automation it doesn't.

[rahul sharma]

when i put my testcase to the target date of today it works with the following

"Target start" = startOfDay() 

[Marc - Devoteam]

Hi @rahul sharma 

Welcome to the community.

Set the number of days as followed: in the JQL  startOfDay("-7d") for past dates or startOfDay("7d") for future dates.

[rahul sharma]

i have tried this JQL but no luck. when I test it in the automation it returns the userstorys that i want to alter but when i run the automation it doesn't. 

Just for reference i did try it with just startOfDay() the flag works