DevForce Community Forum : Query Search on Date Field

Query Search on Date Field : You should be able to construct...

Wed, 22 Jul 2009 13:33:59 -700

Author: kimj
Subject: 1384
Posted: 22-Jul-2009 at 1:33pm

You should be able to construct a query string containing the date - it's just that Entity SQL has a very non-intuitive syntax for date fields. Here's some info from the MSDN - http://msdn.microsoft.com/en-us/library/bb399176.aspx, and here's a link to a similar question here - http://www.ideablade.com/forum/forum_posts.asp?TID=806

Query Search on Date Field : Appears in order to get this to...

Wed, 22 Jul 2009 11:42:03 -700

Author: mbevins1
Subject: 1384
Posted: 22-Jul-2009 at 11:42am

Appears in order to get this to work, you have to use QueryParameters rather than just building out your where clause.

Query Search on Date Field : I am having a hard time trying...

Wed, 22 Jul 2009 07:37:33 -700

Author: mbevins1
Subject: 1384
Posted: 22-Jul-2009 at 7:37am

I am having a hard time trying to figure out how to search on a date only field. How do I create my where clause?

Where schdate = Convert.ToDateTime(dateParameters[0].InputedValue)

No matter what I pass, I get a lot of different errors saying invalid query syntax.

My execution looks something like this:

var query = new PassthruEsqlQuery(entityType, sql);

ObservableCollection<EntityBase> dataSource = new ObservableCollection<EntityBase>(Globals.EntityManager.ExecuteQuery(query).Cast<EntityBase>().ToList());