Results 1 to 3 of 3
  1. #1
    gonzod is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    5

    Need Help quick on Diffdate function


    Need help quickly and I know this is a no brainer for everyone on this site.
    What I have is an Access database with Case Opened, Case Closed and Days Open. What I did was use the Datediff to get the total days when Case Opened and Case Closed are populated and it worked but now I need it to populate the Days Open with the total days when Case Opened is filled and no date is in Case Closed. Basically I need it to count the days it is open using current date with the date it was opened. I know this is all jammed together but I am in a hurry. Thanks for any help!!

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    datediff("d",caseOpenDate,now()) returns days since case open till now.

  3. #3
    gonzod is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2010
    Posts
    5
    Thanks Guys for your help!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. A quick commentary on Access
    By The Vicer in forum Access
    Replies: 2
    Last Post: 07-27-2010, 09:33 AM
  2. Quick Question
    By Imgsolutions in forum Access
    Replies: 3
    Last Post: 07-19-2010, 11:22 AM
  3. Quick Help with Printing
    By Imgsolutions in forum Access
    Replies: 1
    Last Post: 07-06-2010, 02:02 PM
  4. quick query syntax questions
    By cowboy in forum Access
    Replies: 6
    Last Post: 02-03-2010, 06:10 PM
  5. Looking for quick opinion on simple database
    By Zoran in forum Database Design
    Replies: 6
    Last Post: 01-31-2010, 05:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums