Results 1 to 3 of 3
  1. #1
    tsn.s is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Location
    Selby, North Yorkshire, UK
    Posts
    19

    Count days past a set date

    Hi

    I have a field called "Assessment Due" and a field called "Assessment Days Over Due". I am trying to get the "Assessment Days Over Due" to count how many days it has been since the "Assessment Due" date. I've tried datediff but have not had much look with it.

    Any help is appreciated.

    Thanks

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Are you trying to do this in a Query?

    If so - in Query Design have you tried this:
    Code:
     
    Assessment Days Over Due: DateDiff("d", [Assessment Due], Date())
    ?

  3. #3
    tsn.s is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Location
    Selby, North Yorkshire, UK
    Posts
    19
    I see what you mean. I was trying to insert the code into the field on my form which wasn't working how I wanted it to. I put the code into my query and it worked fine.

    Thanks

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

Similar Threads

  1. Replies: 8
    Last Post: 09-23-2012, 01:05 AM
  2. Replies: 2
    Last Post: 10-08-2011, 06:33 PM
  3. Billable Days within date range
    By howsle in forum Reports
    Replies: 1
    Last Post: 07-13-2011, 10:44 AM
  4. Replies: 2
    Last Post: 07-31-2009, 06:56 AM
  5. Date Past Function
    By Laney in forum Access
    Replies: 4
    Last Post: 05-21-2008, 07:19 AM

Tags for this Thread

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