I have built a complex SQL view that checks for users that are not in certain tables on certain dates.
This is working OK when I manually add the date rage "From" and "To" in to the SQL View....
I'm Using a between function for two date like this:
(start BETWEEN '2013-01-01' AND '2013-20-04') AND (stop BETWEEN '2013-01-01' AND '2013-20-04')
What I would like to do now is to Call this View from my ASP page and use two variables for the from and to dates.
Can this be done ?