Sue,

I don't know the answer to your problem - I'm sure it as to do with it being a data field.  Sometimes adding "toJavaDate()" helps but I've not idea here.

In your case I would think about a different approach.  You're doing 3 @DbLookups in a row to the same view.  Even on the Notes Client that's not the best for performance.

I would abandon @DbLookups you don't need them here.  You can create a SSJS function - call that and bring back the 3 return values in one shot.  So only one call to open the view.  In the function you can get all your values, and return them as an array.  There's some information about that in this stackoverflow question.  http://stackoverflow.com/questions/9897636/how-to-pass-variable-parameters-to-an-xpages-ssjs-function

If you write the function in LotusScript first - that might help you in translating it to SSJS.  It would be pretty similar.

Just my 2 cents....

Dave

Thanks for your thoughts.  I had seen your similar reply on others.  I tried the toJavaDate and get NaN.  It really feels like a bug in that only one value is coming back, instead of three.

I guess I don't get it...  But I confuse easily....

when you say you want 3 values back...  is the date field a multi-value field?  And you're getting 1 value but not all?  Maybe I missed that..

Does this work in LotusScript?  All @DbLookup really does under the covers is call a session.eval...  one of the several reasons why I don't like DbLookup...

You might want to break this down to the lowest common problem and post on StackOverFlow... smarter people then me check those out..

Excuse the code: I am typing it without benefit of a Domino Designer Client.  You could write this as a function and pass in the parameters to make it reusable

var db:NotesDatabase = session.getDatabase(sessionScope.SurvDbName);

var view:NotesView = db.getView('AGENTAllSurveys');

var coll:NotesDocumentCollection = view.getAllDocumentsByKey(lookupKey, true);

var doc:NotesDocument = coll.getFirstDocument();

var tmpDoc:NotesDocument;

var returnedValues:java.util.Vector = new java.util.Vector();

while(doc != null)

{

     tmpDoc = coll.getNextDocument(doc);

     returnedValues.add(doc.getItemValue('ReturnedDate'));

     doc.recycle();

     doc = tmpDoc;

}

...then you have the returnedValues Vector to do with what you will.  You can check each value to see if it is null or do a typeof to get its data type, or even both.

Thanks, Rob, that is the solution I went with.  The field from each of the three docs is then available!