Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    New York, NY
    Posts
    3

    Unanswered: Calculate # of days between events in list

    Basically, we have a table of events linked to each client. I've got a report that pulls every change of status in the client's case, but I want to calculate the days elapsed btw Event1 and Event2, down the list. I'm not sure how to do that?

    I'm self-taught on CR, so forgive me if I'm missing something ridiculously basic here...

    So basically I'd want to return:

    ClientName
    6/1/11 0 EventDescr1
    6/3/11 2 EventDescr2
    6/8/11 5 EventDescr3

    Any help appreciated!!
    Stephanie

  2. #2
    Join Date
    Nov 2007
    Posts
    15
    Quote Originally Posted by earthtoned View Post
    Basically, we have a table of events linked to each client. I've got a report that pulls every change of status in the client's case, but I want to calculate the days elapsed btw Event1 and Event2, down the list. I'm not sure how to do that?

    I'm self-taught on CR, so forgive me if I'm missing something ridiculously basic here...

    So basically I'd want to return:

    ClientName
    6/1/11 0 EventDescr1
    6/3/11 2 EventDescr2
    6/8/11 5 EventDescr3

    Any help appreciated!!
    Stephanie
    the only way to learn CR....and reference books.

    two ways to do this. learn formula workshop or just export in excel and use datediff formula (not a known formula in excel)

Posting Permissions

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