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 the current date.  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

So "Target start" <= startOfDay(-7d) doesn't work for example. 

Just to verify i really need the target start attribute to check.

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

[Marc - Devoteam]

Hi @rahul sharma 

Can you provide the following:

1. what type of project is this (e.g., company-managed, team-managed, etc.), 

2. images that show your complete rule.

3. images showing the details of any relevant actions/conditions/branches.

4. images showing the Audit Log details for the rule execution.

5. Explain where the issue is.

[rahul sharma]

Alrighy hope this helps

1. team management

2. my complete rule is as following

3. 

This is the part that when i try this it doesnt work

4.

5. The issue is at number 3. That jql does work in the issues tab when i try and filter my US but when I use it shown as in the picture it does not work. 

Hope this helps. If there is more information needed just let me know please. I really need this to work. Thanks in advance.