Results 1 to 5 of 5
  1. #1
    DMT Dave is offline VIP
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    1,185

    Date Diff In Query


    Hi Guy's, this one should be simple but can't seem to get it right!

    I am trying to add an Overdue field in a query with a DateDiff if there is overdue older than 14 days from InvoiceDate to Now, i think it is the Formatting Now part where i am wrong ??

    Click image for larger version. 

Name:	Capture.JPG 
Views:	18 
Size:	37.1 KB 
ID:	41860

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You haven't said what the problem or result is.
    Maybe it's because DateDiff has no format parameter?

    EDIT - Somehow I missed that this was marked as solved. It's considered helpful to post a solution when you've solved it - helps others who might have the same issue.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    dahveed is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    2
    I need help. I have the following DateDiff Function in a MS Access Query Duration: DateDiff("n",[Ticket_Begin],[Ticket_Submitted]), how can I format is it hh:nn:ss? Thanks in Advance...

  4. #4
    dahveed is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    2

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    What you're doing here is called hijacking the thread because you're not the original poster. Better to start your own and avoid potentially confusing those who might post answers based on what they see that was posted by the original poster. It also helps to separate the notification emails for those who originally responded.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Date Diff to calculate hours.
    By rywello in forum Queries
    Replies: 4
    Last Post: 05-30-2018, 02:13 PM
  2. Replies: 3
    Last Post: 03-02-2016, 09:39 AM
  3. calculating date diff in query or sql
    By RICH48 in forum Access
    Replies: 3
    Last Post: 07-29-2014, 08:53 AM
  4. Date diff on Forum
    By Auto in forum Forms
    Replies: 5
    Last Post: 11-20-2013, 11:00 PM
  5. Date diff trouble
    By Cran29 in forum Queries
    Replies: 3
    Last Post: 03-11-2011, 01:02 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