+ Reply to Thread
Results 1 to 3 of 3

Thread: Most Current Effective Date

  1. 06-03-2009 10:17 AM #1
    jk22
    jk22 is offline Junior Member
    Join Date
    Jun 2009
    Posts
    5

    Default Most Current Effective Date

    Hi,I am writing a crystal report and am working with a table that contains pay rates and effective dates.

    If a person has had pay increases, they have multiple pay rates and effective dates within the table.

    My question is, how would I write the formula to state that I only want the most current effective date?
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!Share on Facebook
    Reply With Quote Reply With Quote  
  2. 06-03-2009 05:37 PM #2
    AvatarJohn
    AvatarJohn is offline Junior Member
    Join Date
    Jun 2009
    Posts
    3

    Default

    Would Maximum(EffDate, EmpID) work for you?
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!Share on Facebook
    Reply With Quote Reply With Quote  
  3. 07-01-2011 11:17 PM #3
    alexmayer
    alexmayer is offline Junior Member
    Join Date
    Jul 2011
    Posts
    4

    Default

    Pm you mate. Kindly check..
    green tea weight loss
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!Share on Facebook
    Reply With Quote Reply With Quote  
+ Reply to Thread
« Previous Thread | Next Thread »

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules