Page 1 of 1

Between

Posted: Thu Apr 26, 2007 9:15 am
by kpraman
I have 2 fields

1. start_date
2 end_date

how can i get inbetween dates?

Posted: Thu Apr 26, 2007 9:35 am
by JayBird

Posted: Thu Apr 26, 2007 9:42 am
by kpraman
I have a page where the start_date - end_date (dates will have hyperlinks), in the query how can i use if the user selects in between dates.

Code: Select all

SELECT * FROM table WHEN userdate Between start_date AND end_date
I am not getting the results

Posted: Thu Apr 26, 2007 10:20 am
by Oren
WHEN should be WHERE.