Concatate Date &Time values from a form & Do Insert

[weezerboy]

I am trying to combine a date value and a time value from a form submission into one datetime value and then insert it into a SQL server 8 data table.

Here are the formats

Date : 03/07/2013

Time : 08:07 PM

So somehow I need to concatate these 2 items and then insert the combined value into a SQL server 8 data table.  (datetime Data Type).

The inserted value should look like this

2013-03-07 20:07:00.000

Any help my dear cold fusion brothers?

[duncancumming · Accepted solution]

You probably want to use ParseDateTime to turn your two strings (concatenate them) into one date object.  See http://www.petefreitag.com/item/569.cfm for a useful example