08-25-2008, 04:09 AM
Join Date: Aug 2008
Carrier: no idea
Post Thanks: 0
Thanked 0 Times in 0 Posts
| | Lotus Notes and MDS, Time converting problem
Please Login to Remove!
I would like to ask you about one thing that worries me. I have an application in MDS which calls a web service from Lotus Notes database. It is quite simple and everything works fine except one converting time data between LN and MDS.
Lets have a example: lotuscript class called Person has firstName(String), LastName(String) and timeArrived(XSD_TIME) variables. In MDS there is a form with edit boxes mapped to variables (standart text data type for String and Date/Time for XSD_TIME). When data are filled in BB device and web service is called, there is a function that creates a document based on the data from BB. All text is all right but there is problem with a time field.
I have set a 10:45 in BB device and the document was created with the value 8:45 (2 hours less).
here is a part of function that creates a item to the document:
Call doc.ReplaceItemValue("Time", Me.timeArrived.GetValueAsNotesDateTime)
So, the value is 8:45 and when I call the function that shows the records (shows objects based on the documents) our record shows right firstName, right lastName and 9:45 (1 hour more than in LN document value).
here is a part of function that converts documents to objects:
Dim dt As New NotesDateTime(GetText(doc, "Time")) 'function GetText just gets the text value of a item
I am in +1 timezone.
I will welcome any step to solution of the problem. Thank you very much for your time.