+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831

    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?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 29
    Last Post: 7th May 2010, 03:26 PM
  2. Creating IIS sites for all domain users using home directories
    By thedarxide in forum Windows Server 2008
    Replies: 10
    Last Post: 30th March 2010, 09:09 AM
  3. Power User status for all Staff
    By mrforgetful in forum MIS Systems
    Replies: 7
    Last Post: 10th September 2007, 09:12 AM
  4. Replies: 2
    Last Post: 11th October 2006, 12:17 PM
  5. for all those who like widgets on mac
    By russdev in forum Educational Software
    Replies: 3
    Last Post: 25th July 2005, 07:19 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •