nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

rahul sharma_lz4i7n

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?

Accepted answers

rahul sharma_lz4i7n

I'm so sorry I found my problem:

Schermafbeelding 2025-10-20 om 14.20.25.png

This was turned on. When I turned it off it works all great.

Thank you for all the help

All comments

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.

Valerie Knapp_gp7rpj

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_lz4i7n

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_lz4i7n

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

rahul sharma_lz4i7n

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

"Target start" = startOfDay()

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_lz4i7n

Alrighy hope this helps

1. team management

2. my complete rule is as following Schermafbeelding 2025-10-18 om 20.49.23.png

3. Schermafbeelding 2025-10-18 om 20.50.22.png

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

4. Schermafbeelding 2025-10-18 om 20.51.30.png

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.

rahul sharma_lz4i7n

I'm so sorry I found my problem:

Schermafbeelding 2025-10-20 om 14.20.25.png

This was turned on. When I turned it off it works all great.

Thank you for all the help

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-service-desk-cloud

automation

jira-service-management-cloud

jira-automation