List of Contributions

No worries. Taco Tuesday is always going to get the best of us! I had a similar idea to yours but I couldn't get the formatting of the effective dates / effective seq in query to work, but I didn't even know about the Julian conversion. That was genius! Thanks again. Scott Cho PeopleSoft ...

Thanks David. Am I reading this right and the logic for the comparison of most recent and the 2nd most recent effective date/eff seq tables are the in view: PS_DU_ADMA_CURPREV? Scott Cho PeopleSoft Campus Solutions Consultant 630/384-9711

Thanks Jeffrie, FYI – I think there is a typo in your SQL: SELECT A.EMPLID, A.AID_YEAR, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFFSEQ, TO_CHAR(B.EFFDT,'YYYY-MM-DD'), B.EFFSEQ FROM PS_STDNT_TERM_BDGT A, PS_STDNT_TERM_BDGT B WHERE ( A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_STDNT_TERM_BDGT ...

Does anyone have a good way to get the the most recent and the 2nd most recent row of a table with effective date and effective sequence? It would be easy if they were different effective dates (and some are), but some also are the same effective date and have a different effective sequence. -- ...

Nope. This is the SQL behind the view: ITEM_ACCT_VW select a.setid, a.item_type, a.descr, a.minimum_amt, a.maximum_amt, a.item_type_cd, a.tender_spec, a.tender_category, a.tuition_deposit, a.keyword1, a.keyword2, a.keyword3 from ps_item_type_tbl a where a.effdt=(select ...