Solved

Agent looking for creation date of documents and returning a total

Posted on 2007-03-19
1
166 Views
Last Modified: 2013-12-18
I need a agent that will parse through all documents in a database and give me a count of the ones created in the year 2006.  If I did not create a date field on my form, is there a way to tell when the document was created?
0
Comment
Question by:Jaziar
1 Comment
 
LVL 19

Accepted Solution

by:
madheeswar earned 250 total points
Comment Utility
try the below code and change it according to ur needs:
Dim session As New NotesSession
      Dim db As NotesDatabase
      Dim view As NotesView
      Dim doc As NotesDocument
      Set db = session.CurrentDatabase
      
      Set view = db.GetView("vue")
      Set doc = view.GetFirstDocument
      While Not doc Is Nothing
            If doc.Hasitem("YourDatefield") Then
                  If Year(doc.YourDatefield(0))="2006" Then
                  'Do the need full
                  End If
            Elseif  Year(doc.Created) = "2006" Then 'Created will give the Date of creation of the document. Or u can use Modified aswell.
                  'do the need full
                  
            End If
            Set doc=view.GetNextDocument(doc)
      Wend
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

5 Experts available now in Live!

Get 1:1 Help Now