Page 1 of 1

Dates query

Posted: Tue Dec 21, 2004 8:08 am
by rp
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

Posted: Tue Dec 21, 2004 8:51 am
by pedrokas
not actually be dates ???

what u mean? truncated dates?

Just to clarify

Posted: Tue Dec 21, 2004 9:30 am
by rp
"actually be dates" (from my post) means actual dates in the DB fields the fields are all formatted yyyy-mm-dd