Very Computer

: Does anyone know if and how you can increment a date.
: I want to set an expiration date, but I don't want to set a specific
: date.  Rather I just want to set the expiration date to be 1 year or 1
: month after the setup date.  How can I do this.

l_exp := SYSDATE + 0.5;
l_exp := SYSDATE + 1;
l_exp := SYSDATE + 30;
l_exp := SYSDATE + 365;

SYSDATE is a function that returns the current system date and time. You could
use it to represent the install time.

In answer to another question about setting dates beyond the year 2000 then
you could always use the to_date and to_char functions along with their
related formats (one of which is 'YYYY').

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can be determined by replacing 'not.valid' with
'value.net'

Does anyone know if and how you can increment a date.

I want to set an expiration date, but I don't want to set a specific
date.  Rather I just want to set the expiration date to be 1 year or 1
month after the setup date.  How can I do this.
If you can, please respond via direct email since I can't check the
newsgroup too often.  Thanks.

--
**************************************
Bryan J. Gentile
Consultant
Business Data Services, Inc.
Glastonbury, CT  06033
Phone: (860) 633-3693 (ext. 3006)
Vmail: (ext. 6030)
**************************************