Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2013
    Posts
    20

    Talking Unanswered: DateStamp Difference

    I have a form that stores a time date stamp when user adds information. I am trying to find the difference from the current form record date stamp and the previous record same form date stamp.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Use one of the datetime functions. Google 'ms access date time function' for details.
    ms Access uses a floating point value to represent dates times. The decimal represents the time as a proportion of the day. 0.5 equates to 12:00:00, 0.75 18:00:00 and so on. The integer part represents the number of days since, IIRC, 31/12/1899 or possibly 01/01/1900.

    Simply subtracting one from t'other will give the number of days. But if you need specific quantitative values use one of the functions
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    And if they're different records you may need something like this first:

    http://allenbrowne.com/subquery-01.html#AnotherRecord
    Paul

  4. #4
    Join Date
    Oct 2013
    Posts
    20
    Thanks everybody the resources was exactly what I needed. Works like a charm.

  5. #5
    Join Date
    Oct 2013
    Posts
    20
    Here is the date code in case someone else reads this post: timelapse: (DateDiff("n",[R3].[Testtime],[tblchemicaltests].[Testtime]))/60 which returns results in hours. Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •