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

DASL Filter function?



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 4th 10, 02:51 PM posted to microsoft.public.outlook.program_addins,microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default DASL Filter function?

I think you're overthinking this.

If a user is in Florida and their settings are correct for local time zone
the data is stored as UTC, compensated by the local time zone offset. If the
user flies to California and they want UTC times to be correct for that
local time zone they can set the Outlook time zone, add an alternate time
zone and/or change the Windows time zone. Then everything is correct for
local time again.

This is the exact same thing for every single date field in every Outlook
item. If when the date values are entered the time zones are correct the
data is correct in UTC and that's all you can ever expect. If the user
changes time zones and doesn't update their settings every single one of
their date fields will be off by some offset to local time.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Mark B" wrote in message
...
Yes I tend to agree.

The only downside to creating an additional user-defined field called
MileStone1LocalTime is if the add-on is stored on somebody'slaptop and
they tend to be a jet-setter (e.g. travelling salesperson) and frequently
enter different timezones. Then the hard-coded local time is no longer
relevent.

I suppose the way around this is to store the UTC offset in settings and
check that it is the same on Addin startup. If it's not I'd probably need
a messagebox saying "time-zone adjustments need to be made -- this can
take a few minutes." and then proceed to loop through all emails in all
folders, updating the user-defined field value and saving each one. This
would need to be on the main thread since if I tried to do it in the
background it would appear to hang.


 




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
Today(S) function in DASL Filter Mark B[_2_] Outlook and VBA 1 January 30th 10 06:25 AM
Today(S) function in DASL Filter Mark B[_2_] Add-ins for Outlook 1 January 30th 10 06:25 AM
How-to remove DASL filter from taskpad Ole Lauridsen Outlook - Calandaring 0 June 30th 08 11:43 AM
birthday DASL-filter rainer.100 Outlook and VBA 1 December 20th 07 08:57 PM
DASL Filter on custom property Jeff Graves Add-ins for Outlook 0 April 8th 07 04:58 AM


All times are GMT +1. The time now is 12:22 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.