Home > IT Answers > Lotus Domino > How do you determine the current database tim...
Help

Question

  Asked: Jun 4 2008   8:15 PM GMT
  Asked by: Rlrcstr

How do you determine the current database time for a Notes database?


Domino 6.5, .NET, Lotus Notes

I'm using C# and Domino COM Objects 1.1 to write an application that sync's data from Notes to a few other applications.

My question is regarding getting just a list of documents modified since a specific date and time. It seems that the useful props and methods for this are not implemented in the COM interfaces. (These would be things like UntilTime and getModifiedDocuments.)

A full sync' is easy, I just pull all the documents. But the next time around I want to do a "delta" sync and pull just the docs that have changed or been added since the last full sync'. I can use the date parameter of the Search method to do this, I think, but I need a way of determining the current database time from the source (local machine date/time may not be appropriate).

How can i quesry the database or session to see what time stamp to use for a sync' operation?

Thanks.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on Lotus Domino and Development.

Looking for relevant Lotus Domino Whitepapers? Visit the SearchDomino.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Brooklynegg  |   Jun 10 2008  2:59PM GMT

Can you share some context and code to show how you get your Domino COM database connection? Is there a session? LotusScript has a Now function that gives the System (server) date. Does COM support that function? I have never used COM and don’t know what would result if you simply tired it and wrote back a result.

From Notes 6.5 Help

Now Function
Returns the current system date and time as a date/time value.
Syntax
Now
Return value
Now returns the current system date and time as a Variant of DataType 7 (Date/Time).
Usage
A date/time value is an eight-byte floating-point value. The integer part represents a serial day counted from the date January 1, 100 AD. The fractional part represents the time as a fraction of a day, measured from midnight on the preceding day.
You can call the function as either Now or Now().

 

Jellybean  |   Jun 12 2008  9:09AM GMT

Once you’ve processed a document (collection) from Notes you could Stamp All the processed documents with a Notes Item
Call notesDocumentCollection.StampAll( itemname, value )

Before you Stamp the documents you must first Save them.