MIS Systems Thread, Creating a report for all staff who were employed between 2 dates? in Technical; I'm trying to create a report for someone here which would specify name, employment start date and leaving date, and ...
9th May 2014, 10:45 AM #1
Creating a report for all staff who were employed between 2 dates?
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?
9th May 2014, 12:09 PM #2
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.
By mattx in forum General Chat
Last Post: 7th May 2010, 04:26 PM
By thedarxide in forum Windows Server 2008
Last Post: 30th March 2010, 10:09 AM
By mrforgetful in forum MIS Systems
Last Post: 10th September 2007, 10:12 AM
By beeswax in forum Downloads
Last Post: 11th October 2006, 01:17 PM
By russdev in forum Educational Software
Last Post: 25th July 2005, 08:19 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)