Hello

I want to execute following query with MSSqlServer 2000 as database.

SELECT * FROM TABLENAME WHERE CurrentDate = 'Date Selected by user'

Well now my date field in the table is smalldatetime

I am using DTPicker on the VB form to get the date: So i am trying to get the date from it as DTPicker1.value


Second query:
I want to sort records on tha basis of dates i.e "between and" sequence

Third query:
I want to get the datareports based on teh date and time

How to do this?

Help me out



I want to get the report