Results 1 to 3 of 3
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Timezone Criteria

    Simply put. Is there a way to make TimeStamps in my Query display in a specific timezone?

    The program is running in multiple states and time zones are causing the reports to look sloppy. Currently I have....

    --Between Date()-1 And Date()--


    So the report shows yesterdays date only.. But people on the East coast are always on the top of the report, because it is gathering the time stamp from the local PC.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I think you will have to use code to adjust the date and use that calculated date value to filter/sort on.
    Last edited by June7; 03-29-2012 at 10:41 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Not quite sure what you want.
    Here are two sites that might help you:

    http://access.mvps.org/access/api/api0024.htm

    http://techdos.com/content/view/25/68/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. criteria
    By kwooten in forum Queries
    Replies: 47
    Last Post: 08-03-2011, 09:12 AM
  2. Replies: 1
    Last Post: 07-13-2011, 11:00 AM
  3. Replies: 1
    Last Post: 06-12-2011, 07:08 AM
  4. Criteria help
    By jcaptchaos2 in forum Access
    Replies: 13
    Last Post: 05-08-2011, 06:49 PM
  5. Search By Criteria - Flexible Criteria Fields
    By lilanngel in forum Access
    Replies: 0
    Last Post: 03-16-2011, 06:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums