Compare today with a static date

[Felix Schmidt]

Hello everybody,

I want to compare today with an exact date. Today is variable.

Something like this:

• today < '2020-06-01'

I tried diffrent functions without any results:

• startOfDay() < '2020-06-01'
• now() < '2020-06-01'

Where is my mistake?

Cheers,

Felix

[Mohamed Benziane]

Hello @Felix Schmidt 

You can try this :

status was "Open" on "2020-08-15"

Hope this helps 

[Felix Schmidt]

Hello @Mohamed Benziane

this helps me a bit but it still gives me the wrong issues.

What i tried:

project in (a, b, c, d) AND status was Open after "2020-08-15"

the result was every issue in the projects that has the status open. I was expecting with the word after that the secons statement should be false. Becouse 2020-08-15 is in the futur.

Do I make any mistake?

[Antoine Berry]

Hi @Felix Schmidt ,

Are you talking about JQL ? What is the requirement behind it ? 

JQL retrieves issues, so you would have to compare a date field to a static/relative date.

, i.e.

created >= '2020-06-01'

created >= startOfMonth()

would work.

[Felix Schmidt]

Hello @Antoine Berry

yes I'm talking about JQL.

I try to find any issue that has an specific status - e.g. open - after a specific date - e.g. 15.08.2020.

for example

status = Open AND startOfDay() >= '2020-08-15'

[Vinutha GR]

Were you able to resolve this? Even i trying to check on the similar lines