Salesforce Date to Date/Time Conversion

=TEXT(A2,"mm/dd/yyyy"), first convert date to full Date
=CONCATENATE(D2,"T00:00:00.000GMT-07:00"), then add on the time component.