INSERT INTO myTable (CreatedOn, TrainingExp) VALUES (GETDATE(), DATEADD(year, 1, GETDATE()))
UPDATE myTable set TrainingExp = DATEADD(year, 1, CreatedOn)
UPDATE [Table name] set [column name] = DateAdd("yyyy, 1, Date())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)