Dates query
Posted: Tue Dec 21, 2004 8:08 am
Hi folks
I hope this one is "simple" but again this fool cant manage it (properly)
I have 2 fields in the DB - both DATE format. Named: start and end
What I am looking for is the sql that allows the user the select specific periods e.g start date of 2004-10-10 end date 2004-12-31 only problem is that these 2 dates may not actually be dates in the relevant DB fileds.
so it going to be something like 'WHERE start> and end<' or similar.
Mark you "other" alternatives may be considered but the start and end represent budget periods that may not have a fixed time span.
Lookingforwrd to some help and as always, much appreciated. thanks
I hope this one is "simple" but again this fool cant manage it (properly)
I have 2 fields in the DB - both DATE format. Named: start and end
What I am looking for is the sql that allows the user the select specific periods e.g start date of 2004-10-10 end date 2004-12-31 only problem is that these 2 dates may not actually be dates in the relevant DB fileds.
so it going to be something like 'WHERE start> and end<' or similar.
Mark you "other" alternatives may be considered but the start and end represent budget periods that may not have a fixed time span.
Lookingforwrd to some help and as always, much appreciated. thanks