Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Functions and Daylight Savings Time (Access 97)

    I'm working on porting a MS Access 97 application to another environment. In the app, the number of seconds elapsed between two dates is required for a certain test. If the time span crosses the DST/ST or ST/DST thresholds, an hour is either gained or lost, respectively. However, it appears that the app was coded using the DateDiff function without consideration of this fact. Can anyone tell me if DateDiff takes DST/ST gains and losses into account?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Functions and Daylight Savings Time (Access 97)

    No, the DateDiff function has no "knowledge" of DST switching, and not of time zones either. You'll have to build in your own checks if you need to take that into account.

Posting Permissions

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