filter with dates

[ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ]

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

[John Funk]

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

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

[ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ]

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]

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

[ΣΟΦΙΑ ΦΟΡΑΔΟΥΛΑ]

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"?