hello all,

i want to search by date in my project. in my database there is field dtCreationDate which store date and time of creation.

my database image : www.freeimagehosting.net/uploads/218743366b.png

now i want to search by date, so want to use LIKE query, by that i can get result.

i am using self servicing.

can you please help me??

The LIKE operator does not really apply to dates, only to string values. Can you give us an idea of the sort of query you want to run, or what you have tried so far?

MTrinder wrote:

The LIKE operator does not really apply to dates, only to string values. Can you give us an idea of the sort of query you want to run, or what you have tried so far?

Hi MTrinder,

Thanks for reply

well i want to search by date. i.e. suppose i will enter date like 05/15/2009, so it will show me the articles list on which date(05/15/2009) it was posted.

but the problem is that in my database date is store (date and time) like :

05/15/2009 4:10:17 PM

so i thought , i can use like query to search on date. so it gives result.

if i am wrong please correct me and give me some solution.

In this case, use DBFunctionCall. You could use this expression (a trick I found here). So it would look like:

IPredicate monthFilter = new EntityField("ArticleCreationDate", 
     new DbFunctionCall("CAST( FLOOR( CAST( {0} AS FLOAT ) ) AS DATETIME )",
     new object[] { ArticleFields.DtCreationDate  })) == someDateTimeValue);

For the rest, do the same you did here: http://llblgen.com/tinyforum/Messages.aspx?ThreadID=15906

daelmo wrote:

In this case, use DBFunctionCall. You could use this expression (a trick I found here). So it would look like:

IPredicate monthFilter = new EntityField("ArticleCreationDate", 
     new DbFunctionCall("CAST( FLOOR( CAST( {0} AS FLOAT ) ) AS DATETIME )",
     new object[] { ArticleFields.DtCreationDate  })) == someDateTimeValue);

For the rest, do the same you did here: http://llblgen.com/tinyforum/Messages.aspx?ThreadID=15906

Hi daelmo

Thanks a lot man,

done it.

daelmo wrote:

In this case, use DBFunctionCall. You could use this expression (a trick I found here). So it would look like:

IPredicate monthFilter = new EntityField("ArticleCreationDate", 
     new DbFunctionCall("CAST( FLOOR( CAST( {0} AS FLOAT ) ) AS DATETIME )",
     new object[] { ArticleFields.DtCreationDate  })) == someDateTimeValue);

For the rest, do the same you did here: http://llblgen.com/tinyforum/Messages.aspx?ThreadID=15906

Hi daelmo

but can u tell me how can i use LIKE Query in self servicing.

if suppose i have i have table and there is field called EmployeeName

so how can i user LIKE Query : e.g. in PredicateExpression

Please use FieldLikePredicate

Walaa wrote:

Please use FieldLikePredicate

Thanks for link walaa. i got it how to do that.

thanks