Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by chrissanderson
-
Check partial date between date range
Oops, I forgot to mention I'm using MS SQL, in fact I've probably posted in the wrong forum. The biggest headache is the partial date that I'm passing (searchdate). With my example that would give: WHERE 31/10/2005 < 11/2005 AND 01/03/2007 > 11/2005 Could I do something like: WHERE...- chrissanderson
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Check partial date between date range
This is my first post on here. Bit of a SQL n00b so please bear with me :o) I have an events search that lets users search by month and year (day is too specific). The events have have both a start and end date that can span over several days, or at the most, years. I'm trying to build a SQL...- chrissanderson
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
