Results 1 to 2 of 2
  1. 08-21-2015, 07:02 AM #1
    jo15765's Avatar
    jo15765
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672

    DateDiff To Show Decimal


    How can I have my Date Diff query give me decimal places (4 to be precise) -- This is my query
    Code:
    Diff: DateDiff('d', [Date1],[Date2])
    Reply With Quote Reply With Quote
  2. 08-21-2015, 07:39 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    days are NOT decimal. you cant have 1/2 a day.

    try hours then divide/24 for hours, and you can have a decimal.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Convert decimal comma to decimal point
    By Hans Karlsson in forum Programming
    Replies: 3
    Last Post: 06-30-2014, 01:56 PM
  2. DateDiff
    By mphynson44 in forum Queries
    Replies: 3
    Last Post: 02-27-2014, 07:28 PM
  3. Datediff()
    By st1300 in forum Programming
    Replies: 6
    Last Post: 12-08-2011, 05:58 PM
  4. DateDiff
    By mrkaye in forum Forms
    Replies: 18
    Last Post: 11-19-2010, 08:19 AM
  5. DateDiff
    By ROB in forum Access
    Replies: 2
    Last Post: 10-30-2010, 03:58 AM

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

Other Forums: Microsoft Office Forums