Most current effective date
I am using a table that has multiple effective dates for employees. How do I write a formula in crystal to obtain the most current effective for each person?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 8, 2009 2:55 PM
UPDATED:
May 11, 2009 5:55 PM
Answer Wiki:
If I understand, what I believe you are looking for is maximum({effective date.field}) you could also just use a running total and achieve the same results.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
