Results 1 to 2 of 2
  1. #1
    iProRyan is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2011
    Location
    England, United Kingdom
    Posts
    44

    Exclamation DateDiff Help

    Hi Guys,



    Need some help with the DateDiff formula. On my overdue rentals form I have some text boxes and in the days overdue box I want it to be the difference between the date it should be due back and the current date.

    In the control source of the "Days Overdue" box I have =DateDiff([d],[DateDueBack],Now())

    This gives me an "?Name" error,

    Any ideas?

    Thanks,
    Ryan

  2. #2
    iProRyan is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2011
    Location
    England, United Kingdom
    Posts
    44
    This issue has now been solved. The issue was [d] should be "d"

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

Similar Threads

  1. DateDiff
    By mrkaye in forum Forms
    Replies: 18
    Last Post: 11-19-2010, 08:19 AM
  2. DateDiff
    By ROB in forum Access
    Replies: 2
    Last Post: 10-30-2010, 03:58 AM
  3. How to use DateDiff?
    By teirrah1995 in forum Queries
    Replies: 10
    Last Post: 10-19-2010, 12:07 PM
  4. Need Help with Datediff
    By gonzod in forum Access
    Replies: 5
    Last Post: 08-26-2010, 02:29 PM
  5. Datediff
    By greggue in forum Queries
    Replies: 2
    Last Post: 08-13-2010, 03:53 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