What is the code for displaying a result in a query by giving two dates, like between two dates.. more...?

Question

In MS Access there is a function you can use in the query that will show all the payments made for a specific date(month/day/year) to another date. That is the Between[date1] AND To[date2] for example. But how can you make that in a ASP VB script? I have to make this: I have to make two textfields, the first date FROM and the second date TO. I hope you can give me some help. Thanks!

Answer 1

I don't know much about VB Script. But in C# what I would do is store the two date values in the right format from the text box and then the text for my SQL query will look something like that:
"Select * FROM ..... Where Date > Date1 and Date < Date2"

Hope that helps