If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

this may depend on your region settings (and I'm not sure if it is the local machine, the server or both) but dates generally have to be in "mm/dd/yyyy" format also for sql server, and i've never used the date/time picker so you may have some issues there.

You could make use of a stored procedure for this, with a couple of parameters...
eg;

Code:

CREATE PROCEDURE spGetInformation(@Date1 SMALLDATETIME, @Date2 SMALLDATETIME) AS
/* Return all the information between date1 and date2, sorted by the date fied */
SELECT
*
FROM
TABLENAME
WHERE
CurrentDate BETWEEN @Date1 AND @Date2
ORDER BY
CurrentDate

Run this from Query Analyzer against your database to create the sproc. Then from your VB client or data report, you can use the sproc as your datasource, or make use of the ADODB.Command object.

* The Perfect Platform for Game Developers: Android
Developing rich, high performance Android games from the ground up is a daunting task. Intel has provided Android developers with a number of tools that can be leveraged by Android game developers.

* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.