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; } } }

request for current date between Date1 from/to or Date2 from/to

Uwe_Speckels

Hello,

who can give me a hint? I have to prepare a JQL date comparison with 2 different dates.

1. 1st of all I have the current date
2. planned project date from/to ---> always filled
3. actual project date from/to -----> sometimes not filled

If the current date is between the planned project date then I have to list the project no. to the project leader. In all other cases no listing depending on actual project date.

If the actual project date is filled then I have to do the same check and listing.

Best regards,
Uwe

Accepted answers

Muthu Thiruppandy

Try the following approach:

project = xx AND planned_start < now() and Planned_end > now() OR project = xx AND Actual_start < now() and Actual_end > now()

All comments

Muthu Thiruppandy

Try the following approach:

project = xx AND planned_start < now() and Planned_end > now() OR project = xx AND Actual_start < now() and Actual_end > now()

Uwe_Speckels

Hello,

you're right with the statement. Thanks.

In this case, I have another question. I can't find any solution in the WWW. How can I calculate with now(). Now() doesn't accept any parameters. How it looks like e.g.:

now() -1y or
now() +15d

Thanks, for further help.

Uwe

Muthu Thiruppandy

You are correct, the function now() does not accept parameters. you can do the same with the function startOfDay(), like startOfDay(1), startOfDay("-2d")

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

project

jira-server

date

compare