This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have records with a dateCreated column of type DateTime. I'm trying to write a query to get all records created after some time of the day (for instance after 22:00), irrespective of the actual date. If I put a.dateCreated.TimeOfDay in my query to compare it with a TimeSpan it doesn't work. How can I deal with this?
|
|
|
|
|
You will need to break out the time components and do an "and" query: a.dateCreated.Hour >= ts.Hours |
|
|
|
