×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dates between rehire/Term

Dates between rehire/Term

Dates between rehire/Term

(OP)
I have a basic rehire/Term report.  I need to only pull anyone who was rehired with in 14 days of termination.  The thing is that we have people who have been termed and rehired more then once....Any suggestions?

I'm on Enterprise 3. ponytails

RE: Dates between rehire/Term

This is a little harder then you may think.  I would assume you just want the last term/rehire pair of JOB records.

I will put screen prints at:
http://CharlesCook.com/Examples/TER_REH/TER_REH.doc

I started by adding a JOB table and giving it an alias of JOB_TER.  Then I added a JOB table and gave it an alias of JOB_REH.  I then linked using JOB_TER.EMPLID = JOB_REH.EMPLID.  Then in selections you need to convert the TER Effective Dating Selection Critera to SQL and edit the SQL so you only get the last TER record.  Then you do the same with the REH Effective Dating Selection Critera so you only get the last REH record.  (WHAT did he say, look at the screen printes to see how to do this).  Then add a derived field to figure out the days between the TER and REH events.  Use this derived field in the selections.

I know this is a bunch to understand but look at the screen prints and it should make sence.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

RE: Dates between rehire/Term

(OP)
Charles,
I don't know if anyone told you this lately, but you "ROCK"!!  Everything worked perfectly!

smarty

RE: Dates between rehire/Term

Your welcome !!!!

Don't forget giving stars....

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close