[sims] Creating a report for all staff who were employed between 2 dates?

[localzuk]

I'm trying to create a report for someone here which would specify name, employment start date and leaving date, and the title of any roles they had.

 

In normal SQL reporting, I'd go down the exclusion route - if the person left before the date exclude them, and if they started after the second date, exclude them.

 

However, there doesn't appear to be a way to do reports in that manner in SIMS.

 

So, how would I generate a list like that?

[vikpaw]

You'd have a condition that was start date before x (end range) AND another condition on leaving date after y (start range), i think that covers you.

You can also use between if you want but that's prob no use to you in this case.