Convert Time Zones

Results 1 to 2 of 2

Thread: Convert Time Zones

  1. #1
    BarWhiz Guest

    Default Convert Time Zones

    I have a MS Access database on a server in the Pacific Time Zone, all new records are date/time stamped with the time there. What I want to do is be able to view the data on the web, but have the time converted to the users time zone. Example, if the time on the record is 8:00 am (pacific) and I view it from somewhere in the central time zone, I want it to convert so it shows 10:00 am (just on the web page, not change the stored time) Any ideas? Thanks.

  2. #2
    Lurker Guest

    Default RE: Convert Time Zones

    The only way I know of is to ask the user where they are and then add or subract from the time on the server using DateAdd().

Posting Permissions

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