×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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!

*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

Need to Begin_Date and End_Date columns to an EFFDT table.

Need to Begin_Date and End_Date columns to an EFFDT table.

Need to Begin_Date and End_Date columns to an EFFDT table.

(OP)
Hi,

Is anyone know of an easy method of populating Begin and Date columns on a Peoplesoft EFFDT based table.

Eg:
From:
DEPTID EFFDT ......
12345 1/1/1900
12345 1/1/2000
12345 2/1/2000
12345 5/1/2000
12345 10/1/2000

TO:
DEPTID EFFDT ...... BEGIN_DT END_DT
12345 1/1/1900 1/1/1900 12/31/1999
12345 1/1/2000 1/1/2000 1/31/2000
12345 2/1/2000 2/1/2000 4/30/2000
12345 5/1/2000 5/1/2000 9/30/2000
12345 10/1/2000 10/1/2000 12/31/9999

Any assistance is appreciated.

Thanks in advance

RE: Need to Begin_Date and End_Date columns to an EFFDT table.

What are you trying to do this in - a report, query, building a new table?  Is it a one-off?

RE: Need to Begin_Date and End_Date columns to an EFFDT table.

It is hard to give assistance when you don't give enough information to work with. You have not responded to a simple questions to clarify your purpose, I can only assume you have no idea what PeopleSoft is all about. Here's some tips that you can ponder:

1. For reports or query you use either Crystal reporting or SQR programming tool.
2. If you are creating or modifying the structure of a table then you must know PeopleTools, data dictionaries and the reorganiztion of the database.
3. If you are asking for some date calculation then there are many ways to do it: Build an api in java, javascript or perl to do date calculation. Using SQR you can convert the dates into century dates and manipulate from there.
4. If you are populating an existing field then use SQR.

My real question here is why do you want to create an end-date? In PeopleSoft EFFDT marks the beginning of a record and the end of another. Maybe are you asking how to get the record(s) with a max or min EFFDT?

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