<div>
You can also use these functions:<br />
<a href="http://www.mrexcel.com/forum/showthread.php?577940-TIME-ZONE-Vba-function-How-to-use-this-fuction" rel="ugc">http://www.mrexcel.com/forum/showthread.php?577940-TIME-ZONE-Vba-function-How-to-use-this-fuction</a>
</div>


You can also use these functions:
http://www.mrexcel.com/forum/showthread.php?577940-TIME-ZONE-Vba-function-How-to-use-this-fuction [http://www.mrexcel.com/forum/showthread.php?577940-TIME-ZONE-Vba-function-How-to-use-this-fuction]

<div>
fabulous feedback - just the orientation I needed.
</div>


fabulous feedback - just the orientation I needed.

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
Gustav, I'm always impressed by your code library. I've said it before: you should publish your samples as articles. In the meantime, I try to catch your solutions in my knowledgebase.<br />
<br />
(°v°)
</div>


Gustav, I'm always impressed by your code library. I've said it before: you should publish your samples as articles. In the meantime, I try to catch your solutions in my knowledgebase.

(°v°)

<div>
Thanks. You are right, but it is hard to find the time. Some day ...<br />
<br />
/gustav
</div>


Thanks. You are right, but it is hard to find the time. Some day ...

/gustav

<div>
<div class="content wysiwyg-content">
Dear experts - <br />
We now have people working in different countries, and will be generating deadlines for various tasks, thus we now need to specify the time zone, and also be able to convert, at least into major time zone groups (e.g., EST, GMT, China time).<br />
Does the native date/time field support this? Do we need custom code?<br />
Any guidance would be much appreciated...<br />
Thanks!
</div>
</div>


Dear experts - 
We now have people working in different countries, and will be generating deadlines for various tasks, thus we now need to specify the time zone, and also be able to convert, at least into major time zone groups (e.g., EST, GMT, China time).
Does the native date/time field support this? Do we need custom code?
Any guidance would be much appreciated...
Thanks!

Time zones in Access: Specifying/displaying/converting

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.