Pass HTML Form Date to VB Variable for SQL insertion -
alright, have simple asp page (summary.asp) - see code: <html> <body> <form action = "summary.asp" method="post"> select day: <input type ="date" name = "selecteddate" /> <input type="submit" value = "submit"/> </form> <% dim selecteddate set selecteddate = date selecteddate=request.form("selecteddate") after want use date selected part of sql query: if selecteddate<>"" sql = "select location_name, [product code], sum(salesquantity) units [sales data] eventenddate = convert(date, getdate()) group [product code],location_name" ... end if %> where intend replace "convert(date, getdate())" date selected in form. i have not yet got part insert date form sql string. know date format html form in right format sql (yyyy-mm-dd), looks vb not format date? maybe i'm missing something, appreciated. thanks... hope makes sen
