Results 1 to 7 of 7

Thread: a difference of 1 hour between 2 dates

Hybrid View

  1. 11-07-2004, 08:38 PM #1
    xordevoreaux
    xordevoreaux is offline Registered User
    Join Date
    Sep 2003
    Location
    in my cube
    Posts
    95
    I left off the brackets. Access added the brackets immediately and it worked.

    Diff: DateDiff("h",[DateStart],[DateEnd])


    I've attached a table with two records, one whose timeframe is 1 minute apart, another greater than an hour, and the criteria is > 1.

    Only the record greater than an hour is returned in the resultset.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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