ASP: search by date ???

[ngaisteve1]

If I have this little search function, which search by date, how my sql should be. I use combo box for the date, just the day and the month, in total of 4 combo box.

From date: DD MM
To date: DD MM

submit button here

Thanks for any help.

[rdove]

Without looking at seeing you code I would say you need something like:

SQL = "Select * from Table Where Date=#" & request.form("ComboBox") & "#;"


I hope this helps

[ngaisteve1]

what's the use of that hash (#)?

[yont1]

# #is used by sql for number format. just " " is used for text and/or(strings)