Adding 2 column dates in Microsoft Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rangecontrol
    New Member
    • Oct 2014
    • 1

    Adding 2 column dates in Microsoft Access

    I have a column called Start Date it reads in this format: 3/13/2015 18:00. I have another column named End Date it reads in the same format.

    I need to find out how many days/hours are logged in between these dates. Thank you for your assistance.

    3/13/2015 18:00 3/15/2015 16:30
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    Simple answer:
    query
    calculated field
    built in function datediff function

    The same can be done in a form as a calculated control; however, I tend to do most calculations at the query level when possible.

    You should also note that:
    Calculated fields misinterpreted

    and

    Calculating elapsed time

    International Dates in Access

    Your question lacks: Version information and context such as query, form, report, macro, and/or VBA. Respectfully, please keep in mind that Bytes is neither a code writing nor homework service. Please read the FAQ and posting guidelines.

    Comment

    Working...