Add Date & Time and Convert to UTC
<p>I have two dates. Date1 and Date2</p>

<p>Date1 contains "10/12/2010 12:00:00AM". Date2 contains "10/10/2010 03:00:00PM"</p>

<p>I want to extract only the date from Date1 and extract only the time from Date2 and join them.</p>

<p>Example "10/12/2010 03:00:00PM".</p>

<p>Any ideas?</p>

<p>Thanks</p>
