Re: date range headache

2009-09-07 Thread Masklinn
On 7 Sep 2009, at 16:35 , Rob B (uk) wrote: > Oh that just makes my brain hurt lol It's not very hard to represent if you just use a few schemas: This is the range of the promotion: A B |--| And these are the possible research range

Re: date range headache

2009-09-07 Thread Rob B (uk)
Oh that just makes my brain hurt lol Works though! thanks On Sep 7, 3:13 pm, Masklinn wrote: > On 7 Sep 2009, at 15:50 , Rob B (uk) wrote:http://dpaste.com/90621/ > > > (The code in above obviously isn't going to work I'm just using it to > > help illustrate my problem.) > > > I want to show a

Re: date range headache

2009-09-07 Thread Masklinn
On 7 Sep 2009, at 15:50 , Rob B (uk) wrote: http://dpaste.com/90621/ > (The code in above obviously isn't going to work I'm just using it to > help illustrate my problem.) > > I want to show all active promotions between the start date and end > date. > So if a promotion starts on 01/01/09 and end

date range headache

2009-09-07 Thread Rob B (uk)
http://dpaste.com/90621/ (The code in above obviously isn't going to work I'm just using it to help illustrate my problem.) I want to show all active promotions between the start date and end date. So if a promotion starts on 01/01/09 and ends 30/01/09 and a person searches from 01/12/08 to 01/02