I'm using ASP and a MSSql database. What I need to do is run a report where the transaction is dated between two dates. For example: I want a report of any transaction between 10/1/2007 at 5:00 pm and 10/3/2007 at 10:15 am.

What's the best way to do this. My end users are entering their requests with a date field and a time field.

Thanks in advance for any help.

Your query would look something like this:

SELECT * from [table] where [date] between '10/01/2007 5:00 PM' AND '10/03/2007 10:15 AM'

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

One more quick question, since my users are entering two separate variables for date and time, is there any way to join them? For example: datenum=10/3/2007 and timenum=05:00. Will a "&" join them for a date variable?

THANKS!!

If you are doing it in code, a simple sting can be passed into a stored proc for a datetime field, as long as it is a valid date time so:

string sDate = txtDate.Text + " " + txtTime.Text; //let txtDate == 10/3/2007 and let time == 05:00

result 10/3/2007 05:00

the & will work in VB but not in C#, C# uses the + as the concatenation operator as demonstrated above.

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

I'm using VB and ASP and MSSql, will the above work for that?

>< I am so sorry. I am used to trolling the ASP.NET/C#/VB.NET forums that i posted C# code. Wow.

You would have to do something like this:

Dim sDate1
Dim sDate2
Dim sSql

sDate1 = CStr(Request.Form("txtDate1")) & " " & CStr(Request.Form("txtTime1"))
sDate2 = CStr(Request.Form("txtDate2")) & " " & CStr(Request.Form("txtTime2"))
sSql = "SELECT * from [table] where [date] between '" & sDate1 & "' AND '" & sDate2 &"'"

This, of course, is the dynamic sql approach. You could just as easily pass sDate1 and sDate2 into a stored procedure.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Beginning Visual C# 2008
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========