chrisryhal
asked on
add/sub value of 2 columns and get difference
Ok, I have it down, on how to perform my update for dates, based on column values:
UPDATE TL_Calibration SET [Next Calib] = DATEADD(day, InspectionFrequency, [Last Calibrated])
The question I have now is how to take two columns, with date values, and insert the difference into a column. Here is an example of what I am talking about:
[Last Calibrated] [Next Calib] = Days
-------------------------- ---------- ---------- ---------- ---
04/01/05 04/05/05 4 <------WHERE "4" IS HOW MANY DAYS LEFT
UPDATE TL_Calibration SET [Next Calib] = DATEADD(day, InspectionFrequency, [Last Calibrated])
The question I have now is how to take two columns, with date values, and insert the difference into a column. Here is an example of what I am talking about:
[Last Calibrated] [Next Calib] = Days
--------------------------
04/01/05 04/05/05 4 <------WHERE "4" IS HOW MANY DAYS LEFT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
CR