I have a button in a form that uses the following code to convert a time selected in a dialog box into a Date/Time:
tmp = Evaluate(“FIELD TimeRange := @TextToTime(”“” & doc.StartTime(0) & “”“);TimeRange”, currentDoc)
doc.StartTime(0) is a text value, like “08:00”, “13:30”, etc.
I run this code on my Notes 7.0.2 client on WinXP, it returns “12/30/1899 08:00:00 AM EST”, as I’d expect. However, when users in Italy run the code, they get “11/26/1899 08:00:00 AM CET”.
While this is OK when only one time is entered, it causes problems when both a start and an end time are entered by the user. In this case, my form attempts to calculate the elapsed time as the difference between the end time and start time. This calculation results in an erroneous number if the dates for the start and end time are not both “12/30/1899”.
For example the difference between 11/09/2000 12:00:00 AM CET and 11/11/2030 12:00:00 AM CET is 263016.
Has anyone else experienced this behavior before?