Proper syntax for "created before 2021" ?

[Johanna Metzger]

Hello, 

Can you please help to select the proper syntax (in the advanced JQL search)  to retrieve all tickets created before 2021 ?

I tried to select "created < endOfYear(2020)" but it does not work..

Did not find any clue on Syntax help page

Thanks a lot for your support

Johanna

[Olga Videc · Accepted solution]

Hello @Johanna Metzger 

Welcome to the community.

The most basic syntax is created <= 2021-01-01

What Alex said is correct.

Advice, if ever in doubt, use basic search created date between blank and 1/Jan/21 search

after that switch to JQL and you will see the syntax behind it. 

BR, Olga

[Alex Koxaras -Relational-]

Hi @Johanna Metzger and welcome to the community!

The proper syntax will be

• created <= endOfYear() for all issues before the end of the year 2021
• created <= endOfYear(-1) for all issues before the end of the year 2020

You can read more here.

[Johanna Metzger]

Thank you both for your help !! It works fine.

And indeed it is quite more accurate using "created <= 2021-01-01" specific date !

Kind regards

Johanna