Member Avatar for Maya Pawar

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

and

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...

  • 3 Contributors
  • 2 Replies
  • 94 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by crapulency
Member Avatar for rkmasternet

label1.Text = System.DateTime.Now.ToShortDateString();

Member Avatar for crapulency

try this

select * from Stock where (CDate(Int(Timing))) = #23/07/2010#

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.