Date+Time conversion

I have a pull down menu with the following dates and times.
6/30/2004 2:35:20 PM
6/30/2004 2:34:59 PM
6/30/2004 1:10:34 PM
6/30/2004 1:10:20 PM

I need to send a SQL query string to my MS SQL server from an ASP.net(VB) page to filter records based on date and time.

CDate() function does not really work. I tried using CDate(dropInputDate.SelectedItem.Text)

Can some one please help ??
Thanks.

Comments

  • : I have a pull down menu with the following dates and times.
    : 6/30/2004 2:35:20 PM
    : 6/30/2004 2:34:59 PM
    : 6/30/2004 1:10:34 PM
    : 6/30/2004 1:10:20 PM
    :
    : I need to send a SQL query string to my MS SQL server from an ASP.net(VB) page to filter records based on date and time.
    :
    : CDate() function does not really work. I tried using CDate(dropInputDate.SelectedItem.Text)
    :
    : Can some one please help ??
    : Thanks.
    :

    Can you show the sql you are using?

  • DateTime.Parse() would be the fuction that you want to use... not CDate()


    I hope this helps!

    coderforrent.com
    "Get a job, you bum"

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories