Link to home
Start Free TrialLog in
Avatar of dominoPgr
dominoPgr

asked on

Inconsistent date field in Lotus Notes

We have people in offices around the world in US, Europe and Asia to use Lotus Notes database for issue tracking. In lotus notes document, we have date field stamped using @Now in Formula in Domino Designer.

The problem is that people in Asia having time as 13 hours ahead of US.  So the time stamp by user in Asia is 13 hours ahead of time stamp of U. S. Users. I believe the time stamp (@Now in Formula) comes from the Clock on the user's PC. Is there a way to make the time stamp (@Now) to use a same clock like the clock where the Lotus Notes server runs so that users around the globe can be consistent with the same clock?
Avatar of ThomasMcA2
ThomasMcA2

Notes/Domino do that automatically, but only if the field on the form is defined as a date field. I suspect that yours is defined as a text field. Someone will need to change the design of the form, and then re-save or refresh your existing documents. One downside to doing that is that all documents will have a change date of the day that the refresh happens.
You can use the flags, @Now([ServerTime]:[NoCache]; "ServerName/Domain");
You can also include a list of servers.  Note, make sure the users everywhere all have access to the server in the list.  
This will return the current time as on that specified server.
Avatar of dominoPgr

ASKER

Thank you TobyJH! Specify [ServerTime] parameter should work for me.

What about in Lotus Script, for example?
   Dim dateStamp As NotesDateTime
   Set dateStamp = New NotesDateTime("Today")

Is there a way to specify to use Lotus Notes server date/time?
SOLUTION
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you TobyJH!