Solved

Agent looking for creation date of documents and returning a total

Posted on 2007-03-19
1
175 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
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 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