Calculated days added to SYSDATE [WAS: (no subject)]

[Darren Reely]

--------------090004090705090608050301
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

If I've interpreted your broken english correctly, here is a Quiz 
example I think will help you. The days function counts from 19000101. 
Run the sample to see what you get.

define begin-date-range date = 20030929
define todays-date date = sysdate
define before-range num = days(todays-date) - days(begin-date-range)
define newdate date = date(days(todays-date) + before-range)
report all

The short version is:
define begin-date-range date = 20030929
define newdate date = date( days(sysdate) + (days(sysdate) - 
days(begin-date-range)) )

Darren


Valentin Martínez wrote:

> Hello to all. greetings. 
> Waiting that you have or have had an excellent day. 
>  
> Could they tell me I eat up to obtain the I number of working days 
> inside a range of dates so that this result to add it to the current 
> date?  
>  
> Environment - UNIX - Powerhouse 8.23.D4   -   Oracle-815. 
>  
> thank you in advance
>  
> -------------------------------------------------------------------------
> Jesús Valentín Martínez de Haro
> Analista de sistema
> vmtnez@emyco.com <mailto:vmtnez@emyco.com> 
>  



--------------090004090705090608050301--