[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



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.