Results 1 to 7 of 7

Thread: How can I convert GMT time to EST time in MS Access?

  1. Jun 18th, 2003, 08:29 AM #1
    Joanny
    Joanny is offline

    Thread Starter
    New Member
    Join Date
    Aug 2002
    Posts
    11

    How can I convert GMT time to EST time in MS Access?

    Does anybody know how to convert GMT time to EST time in Access?

    Thank you!
    Reply With Quote Reply With Quote
  2. Jun 18th, 2003, 08:31 AM #2
    techyspecy
    techyspecy is offline
    Let me in .. techyspecy's Avatar
    Join Date
    Aug 2002
    Location
    Back to VBF.
    Posts
    2,456

    Re: How can I convert GMT time to EST time in MS Access?

    Originally posted by Joanny
    Does anybody know how to convert GMT time to EST time in Access?

    Thank you!
    What do you mean in Access ???? I do not think Access has any built in function that will do this kind of converion .. Write code pal ...
    Reply With Quote Reply With Quote
  3. Jun 18th, 2003, 08:35 AM #3
    Joanny
    Joanny is offline

    Thread Starter
    New Member
    Join Date
    Aug 2002
    Posts
    11

    GMT -> EST time

    Thanks

    Actually I get the data from server and they are a txt format, then I import to Access, that's the GMT time, I have to convert them to EST time, how should I do?
    Reply With Quote Reply With Quote
  4. Jun 18th, 2003, 08:39 AM #4
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    Well, I can tell you from experience that Central time is -6GMT.... and Eastern is -5GMT..... and Pacific is -8GMT......

    So, if you have the current time in GMT....
    Subtract 5 hours to get the Eastern time....
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  6. Jun 18th, 2003, 08:51 AM #5
    Joanny
    Joanny is offline

    Thread Starter
    New Member
    Join Date
    Aug 2002
    Posts
    11
    I know I need to add 4 hours to it at here. But how should I add it?
    Reply With Quote Reply With Quote
  7. Jun 18th, 2003, 09:54 AM #6
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687
    Originally posted by Joanny
    I know I need to add 4 hours to it at here. But how should I add it?
    Use the DATEADD function.....
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  8. Jun 18th, 2003, 11:18 AM #7
    Joanny
    Joanny is offline

    Thread Starter
    New Member
    Join Date
    Aug 2002
    Posts
    11
    Got it!

    Thank you!
    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


Click Here to Expand Forum to Full Width