how use the PropertyName.createCreationDate() in a Property Queries

[Former Member]

Hi, Does any body know how can i use the PropertyName.createCreationDate() in a Property Query? This is the situation: I created a program in java that select documents from a folder base on the author but need include also the creation date, i am using the manager.IPropertySearchManager for this. Using only the Property Query for author the program show documents but when use the creation date criteria do not show me any document even exist documents for this date. I include part of my code:

IQueryExpression queryExpr = queryBldr.eq(PropertyName.createCreatedBy(), "cmchmfm").and(queryBldr.like(PropertyName.createCreationDate(), "2/9/06%"));

[Former Member · Accepted solution]

Hi,

The Date format returned will be like

"Mon Mar 13 17:00:00 GMT+05:30 2006".

Try this date format

IQueryExpression queryExpr = queryBldr.eq(PropertyName.createCreatedBy(), "cmchmfm").and(queryBldr.like(PropertyName.createCreationDate(), "%Feb 09%2006"));

Regards,

Uma

Message was edited by: Uma Maheswari