Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Compare today with a static date

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?




2 answers

0 votes
Antoine Berry Community Leader Feb 10, 2020

Hi @felix_s ,

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.

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'
0 votes

Hello @felix_s 

You can try this :

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


Hope this helps 

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?

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you