Solved

Agent looking for creation date of documents and returning a total

Posted on 2007-03-19
1
177 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 19

Accepted Solution

by:
madheeswar earned 250 total points
ID: 18748099
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Peculiar IBM Lotus Notes / Cisco VPN Issue 21 947
Lotus notes error message 6 113
Disable some Lotus eMail users for a period of time 4 105
ESXCLI upgrade command 1 160
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

732 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