In excel 2010, I am placing the following syntax in each row of the excel spreadsheet.
= "Update trans set c_date = 'DATEVALUE("&P1&")' where trans_ID = '"&D1&"'"
I want to obtain the trans_id and c_date values from each applicable column. I am obtaining the
trans_id value with no problem. However I am having a problem obtaining the C_date value in the


format I need it to be. I would like the date to look like the following:
2013-01-29 17:04:00.207. This format is yyyy-mm-dd hh:mm:ss:000. The date can be in a short date format.
I originally obtained the value in the C_date column from a sql server 2008 database.
Thus can you tell me what I need to do obtain the C_date value in the format I need?