developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum


Date & time problem in agent
Baba Tony 02/22/2013 05:45 AM
Applications Development All Releases All Platforms

Dear All,

In client application there is one agent, according to this agent code mail send to customer after 24 hours for take action in document, this agent was working fine some time ago but suddenly customer saying that he is not getting email.
I have also checked the view log of agent and found that agent has run.
When i checked the code at my end then found that might be problem is date problem, I have used this code

Dim session As New Notessession
Dim view As NotesView
Dim db As NotesDatabase
Dim doc As NotesDocument
Dim maildoc As NotesDocument
Dim rtitem As notesrichtextitem
Dim calcdate As Variant
Dim current As Variant
Dim docmail As NotesDocument

Set db = session.CurrentDatabase
Set view = db.GetView("AllDocument")
Set doc = view.GetFirstDocument

calcdate = Evaluate("@Adjust(@Accessed;0;0;0;24;0;0)",doc)
current= Now()
If current> calcdate (0) Then
Msgbox("Yes")''some mailing code but for testing i have used msgbox for "yes" and "No"
End If

This code is not working at my end but when i change the value of "current" from Now to hard coded value ex "22-02-2013 15:50:34" then its working fine.
But strange is that customer says that it was working fine some time ago in production.
Please suggest what is the reason and what can I do..

Thanks in advance.

Go back