I have a custom out of office application that helps people keep track of vacation days, sick days, etc. in a calendar format. A lot of the functionality for this application hinges on a date/time field called “ThisRequestDate”. However, we are having some issues related to time zones and how values are saved in this field. When a request form is submitted with the date of the request, the value is saved with a time value of 12:00:00 AM within the user’s time zone. Then if the request is accessed by a user in a different time zone and saved, the time is converted to that user’s time zone, and this can cause a shift in the date.
For example, a user in the UK creates a vacation request for 2/18/10. The value saves in the ThisRequestDate field as “02/18/10 12:00:00 AM GMT”. Now, if someone in the Eastern Time Zone opens this request to approve it, the date value is shifted back five hours to “02/17/10 7:00:00 PM”.
What I want to do is save the field without appending a time value to it when saving, so that users in other time zone don’t inadvertently convert the value. I’ve tried using the DateOnly property in LotusScript, changing field settings, and other tricks with no luck. If anyone can offer some advice, I’d appreciate it. If you need any more information, let me know. Thanks in advance!