[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Adding Number Column to Date Column
- Subject: Adding Number Column to Date Column
- From: Dawn Dennis <76105.3147@COMPUSERVE.COM>
- Date: Mon, 18 Dec 1995 17:58:02 EST
I am having a problem doing date arithmetic in my SQR:
I've got two columns:
incident_dt date format
restricted_days number format
In my SQR all I want to do is add the restricted_days to the incident_dt and
print out the result as a date. For example if the incident_dt is 12/18/95 and
the restricted_days is 2 then I want the result to be 12/20/95. Any help is
greatly appreciated.