I need to understand the difference between the below three JQLs-

[Priyanka khare]

Hello,

I need to understand the difference between the below three JQLs-

created >= -30d

createdDate >= -30d

createdDate >= startOfDay(-30d)

Regards

Priyanka

[Walter Buggenhout · Accepted solution]

Hi @Priyanka khare ,

The first 2 are exactly the same. Both created and createdDate are ways to refer to the system date/time logged automatically when a ticket was created. -30d simply means count back 30 days from that moment.

StartOfDay(-30d) counts back 30 days from 0.00 AM on the current day. Essentially you count back 30 days from the date switch on the calendar.

[Priyanka khare]

@Walter Buggenhout 

Thankyou for the answer.

If i need to access the number of stories created within the last 30 days then my JQL should be-

type= story and createdDate >= -30D

OR

type = story and createdDate >= startOfDay(-30D)

[Walter Buggenhout]

issuetype = Story and createdDate >= -30d

[Tansu Akdeniz]

Hi @Priyanka khare 

There is no difference between created and createdDate. It is just like an alias, both can be used. Also it is not the only one. Type/issuetype, key/issuekey, due/duedate are some other examples.

All queries should return same result.

[Priyanka khare]

@Tansu Akdeniz 

Thankyou for the answer.

If i need to access the number of stories created within the last 30 days then my JQL should be-

type= story and createdDate >= -30D

OR

type = story and createdDate >= startOfDay(-30D)