string sqlUpdateTotalMade = "Insert into Totalmade (FactoryID, AreaID, DaysNightsID, Product, Amount, RecordDate)
Select FactoryID, AreaID, DaysNightsID, Product, Amount, getDate() from TempTotalMade where FactoryID ='" + Vault.FACTORY + "' and AreaID = '" + Program.MAKE + "'";
That should do it
Edit:
<pre lang="c#">string sqlUpdateTotalMade = "Insert into Totalmade (FactoryID, AreaID, DaysNightsID, Product, Amount, RecordDate)
Select FactoryID, AreaID, DaysNightsID, Product, Amount, '" + String.Format("{0:u}", make.nextdate) + "' from TempTotalMade where FactoryID ='" + Vault.FACTORY + "' and AreaID = '" + Program.MAKE + "'"; </pre>