Creating Date & Time

I'm trying to turn a couple of variables into dates and times. I believe I got the date part correct, but the time part is confusing me.

Code: Select all

newmonth = request.form("monthtest")
newyear = request.form("Season_Year")
newday = request.form("frmDay")

newdate = newmonth & "/" & newday & "/" & newyear
Response.Write MonthName(Month(newdate), True)
Response.Write "<br />"
Response.Write Day(newdate)

This seems to work, but I haven't tested it yet. The problem I have now is trying to get some variables from a form into a time.
What I am trying to do is make a schedule. The user puts in the date and time through drop downs and I save these to a database.
I was able to get the info into the schedule, but then I realized that I can't get them to order correctly since they are not dates and time.
So, what I need to do is grab three fields, hour, minute and AM/PM put these together and turn it into a time so that I can get the schedule correct.
I might have an idea to do it without it being a real time, but I would like it to be so if I can.

From http://www.w3schools.com/vbscript/vb..._functions.asp
use CDate