+ Reply to Thread
Results 1 to 3 of 3

Thread: Date calculations for two different categories

  1. 04-16-2010 01:35 PM #1
    nwalsh
    nwalsh is offline Junior Member
    Join Date
    Apr 2010
    Posts
    3

    Default Date calculations for two different categories

    Crystal Reports
    I have two fields with codes of Admission and Sanction but I need to calculate the date between these two events. The date is the same field.

    Admission - Incident date of 4/1/2010
    Sanction - Incident date of 4/12/2010

    It should then show 11 days in a separate column.
    Any help would be appreciated.
    Nancy
    Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiTweet this Post!Share on Facebook
    Reply With Quote Reply With Quote  
  2. 04-21-2010 01:59 PM #2
    crystalreportstips.com
    crystalreportstips.com is offline Administrator
    Join Date
    May 2009
    Posts
    2

    Default

    You can use the DATEDIFF formula to calculate the differene between the two dates. Just go to Help in Crystal Reports and search for DATEDIFF. It will then show you how to write the formula.
    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:16 PM #3
    alexmayer
    alexmayer is offline Junior Member
    Join Date
    Jul 2011
    Posts
    4

    Default

    Yes, ive tried to use that one too.. Just like what crystal report said.
    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