DocumentCollection on Date column

I am attempting to use java to build a document collection using getalldocumentsbykey.

The view column has @date(dateTime) as the value of the column and returns the date of the appointment.

I have tried sending a string value, a date value, a vector, etc, but nothing seems to work.

Could someone explain what I need to pass in for it to work?

Thanks

Subject: DocumentCollection on Date column

See if the following code helps:

Session session = getSession();

AgentContext agentContext = session.getAgentContext();

Database db = agentContext.getCurrentDatabase();

View vw = db.getView(“Test”);

//specify date you are looking for

DateTime dt = session.createDateTime(“04/21/2009”);

DocumentCollection dc = vw.getAllDocumentsByKey(dt);

		System.out.println("Count: " + dc.getCount());