A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Converting date to UTC



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 4th 07, 05:48 PM posted to microsoft.public.outlook.program_vba
HolgerMaune
external usenet poster
 
Posts: 1
Default Converting date to UTC

Is there any possibility in vba to convert a datetime from a know timezone to
utc?
  #2  
Old January 4th 07, 06:29 PM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Converting date to UTC

Only in Outlook 2007 using the new TimeZones collection (returned by
Application.Timezones) or PropertyAccessor.LocalTimeToUTC (see
MailItem/Folder/Store/Attachment.PropertyAccessor property, local timezone
only).
plug Next version of Redemption will expose Timezones in all version of
Outlook and will allow to convert datetime from a given timezone to UTC
using RDOTimezone.LocalTimeToUTC (Outlook 2007 only allows to use
Timezones.ConvertTime with 2 time zones specified as parameters, but it does
not explicitly let you retrieve the UTC timezone) /plug

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

"HolgerMaune" wrote in message
...
Is there any possibility in vba to convert a datetime from a know timezone
to
utc?



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting From Lotus Notes RobGould Outlook - General Queries 1 December 20th 06 08:20 PM
Converting PST to PDF using Linux [email protected] Outlook - General Queries 8 November 7th 06 09:07 AM
Outlook 2007 improperly interprets local time as UTC Brent Paloutzian Outlook - Calandaring 1 October 23rd 06 07:46 PM
Converting an email to calendar apointment RHamada Outlook - Calandaring 11 July 14th 06 09:58 PM
Default Fonts When Converting to HTML? - Outlook - General Queries 1 June 19th 06 12:56 AM


All times are GMT +1. The time now is 08:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.