update job set CLEARANCESTATUS = 'Y', CLEARANCEDATE = getdate() , LANDEDDATE = getdate(), LANDEDSTATUS = 'Y' where id = 5517
update job set CLEARANCESTATUS = 'Y', CLEARANCEDATE = DATEADD(d, -7, getdate()) , LANDEDDATE = getdate(), LANDEDSTATUS = 'Y' where id = 5517
DATEADD(d,"Days you want to add or subtract(int)",Getdate())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)