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

[Roger Kesterson]

Jesus, did you use spanish to english translation software to translate your
message?  Those programs often yield unexpected results.

> -----Original Message-----
> From: Darren Reely [mailto:darren.reely@latticesemi.com]
> Sent: Tuesday, September 30, 2003 9:45 AM
> To: Valentin Martínez
> Cc: powerh-l@lists.swau.edu
> Subject: Re: Calculated days added to SYSDATE [WAS: (no subject)]
> 
> 
> 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> 
> >  
> 
> 
>