Update SQL Server table field with current date time


#1

Could someone help me!!

This is the sql I tried to execute: UPDATE BragiCharger SET RunDate = getdate() Where SerialNumber = ‘" + SerialNumber + "’"

It produced the following error (I think because “getdate()” is not a column: ‘Column Description does not belong to table’

I also tried using CurrentDate activity and add the variable the result goes into, into the sql string:

“UPDATE BragiCharger SET RunDate = '” + currentDate.ToString + “’ Where SerialNumber = '” + SerialNumber + “’”

Same error.