Hi friends,
Plz anybody can tell me,
How to retrieve only date from DateTime in vb.net in dd/MM/yyyy format


I have a field in table in access 2007 which has date/time datatype.

Data is stored in datetime format.(04/08/2010 12:01:07 AM)

I want to retrive only dates which are in range of two DTPickers in dd/MM/yyyy format

I m giving the query below:

cmd.CommandText = "select * from Stock where (CDate(Timing)) >='#23/07/2010#' and (CDate(Timing))<='#02/08/2010#'

Stock is my table in access.
Timing is date/time field.
when i use CDate .it retrieve date & time both.I want only date.
And when i run this query, records are displayed

Can u plz tell me,is there any query in access that we can retrieve the date only from datetime in dd/mm/yyyy format.

Plz dear all help me.
I m in trouble.
One day is already waste bcoz of this.

Thanks in advance....................
Help me...

7 Years
Discussion Span
Last Post by crapulency
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.