Date Searching

donaldt · #1 (**permalink**) 07-22-03, 04:00

My problem......

I have a SQL db that I need to search a date range on - on my form I have to fields that a user will enter 2 dates.

I need to search the db datetime field for date range specified on the form.

Can anyone help ?

Thanks

Memnoch1207 · #2 (**permalink**) 07-23-03, 01:09

lets assume the 2 fields are startDate and endDate

Code:

SELECT * FROM tableName WHERE dateField >= '" & Request.Form("startDate") & "' AND dateField <= '" & Request.Form("endDate") & "'

or

SELECT * FROM tableName WHERE dateField BETWEEN '" & Request.Form("startDate") & "' AND '" & Request.Form("endDate") & "'

donaldt · #3 (**permalink**) 07-23-03, 03:01

Hi Memnoch1207

Understand you reply - thanks, one thing im not sure of is that on my actual form fields do I have to specify anything as I am getting http error 500.

Can you help ?

Thanks

Quote:

Originally posted by Memnoch1207
lets assume the 2 fields are startDate and endDate

Code:

SELECT * FROM tableName WHERE dateField >= '" & Request.Form("startDate") & "' AND dateField <= '" & Request.Form("endDate") & "'

or

SELECT * FROM tableName WHERE dateField BETWEEN '" & Request.Form("startDate") & "' AND '" & Request.Form("endDate") & "'

donaldt · #4 (**permalink**) 07-23-03, 03:04

I have attached the search and results page if you can take a look ?

Any help appreicated !

Donald

Quote:

Originally posted by Memnoch1207
lets assume the 2 fields are startDate and endDate

Code:

SELECT * FROM tableName WHERE dateField >= '" & Request.Form("startDate") & "' AND dateField <= '" & Request.Form("endDate") & "'

or

SELECT * FROM tableName WHERE dateField BETWEEN '" & Request.Form("startDate") & "' AND '" & Request.Form("endDate") & "'

Internet Services

Web Development

Digital Marketing

Consumer Tech