Report what was open on a date

[gerardjohnson]

Hello I have a client in a separate Eureka instance who wants to know what was in any Open state for a particular date.

Sounds simple but there's no report filter condition for State > is > Open > on > 29/02/16 for example.

My instance does a scheduled daily report so we can look into the past, but it seems like the sort of information that would be searchable somehow like a history log which clients don't have access to this so...

Any ideas?

[donrb5]

Would this work?

I think this might work (still trying to figure out how to proof it).

Resolved set to After the date and time desired.

Or Active is True if still open

and finally

Opened set to Before the date and Time desired