Problem in Date

Results 1 to 3 of 3

Thread: Problem in Date

  1. #1
    Join Date
    Dec 1969

    Default Problem in Date

    How can i concatenate date.Actually i am using drop down list for month,day,year and collecting values in other asp<BR>using request.form but i dont know how to put three values in one variable and then use in insert into statement.If you need<BR>any more clarifications then please let me know.<BR>Thankx in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Problem in Date

    Try this<BR>DIM tempDate<BR>&#039make sure its all in one line<BR>tempDate = Request.form("Month") & "/" & Request.form("Day") & "/" & Request.form("year") <BR>&#039now insert into table<BR><BR>strsql = "insert into tablename values(&#039" & tempDate & "&#039)<BR><BR>Hope this help<BR>Asif<BR>

  3. #3
    Join Date
    Dec 1969
    Los Angeles, CA

    Default ASP???....ADVANCED????

    dtmCompleteDate = request.form("Month Combobox") & "/" & request.form("Day Combobox") & "/" request.form("Year Combobox") <BR><BR>You will have to also have the values set to the same data you are displaying in each combo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts