The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

filter with dates

ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ
June 13, 2024

I need to have number of defects that were open/in progress now() - 1day i.e.  1 day exactly before than now 

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
John Funk
Community Champion
June 13, 2024

Hi @ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ 

Try this: project = ABC andstatus was in (Open, "In Progress") on startOfDay(-1d)

ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ
June 13, 2024

but if now() is the real now (date and time) -> startofDay (-1d) will show defects open/in progress at 00:00 yesterday and not now time-24h exactly... correct ?

John Funk
Community Champion
June 13, 2024

Probably, So you might try this then. 

status was in (Open, "In Progress") on -1d

you would have to look at the timings if you have one in mind. This might show everything the previous day and not just the exact 24 hours. you might also try -24h

ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ
June 13, 2024

perfect! - it worked!

Just another similar question - and how can i get number of defect open/in progress "today at 8 in the morning" and then also "yesterday at 8 in the morning"?

TAGS
AUG Leaders

Atlassian Community Events