Re: Serial Date formula

[Glenn Ericson <Glenn-Ericson@xxxxxxx>]

Midas-Kapiti uses serial dates in their banking software.
I do not know  what the base  date is/was 

Jeff  Bull, you  our there and care to share that ?


At 06:21 AM 04/13/2001 -0700, James W. Kilgore wrote:
> Neil,
>
> I suppose duration is like field positions, end - begin +1 = length
>
> If I made an adjustment for 1 that would bring it to 12-31-1899 as the
> 0
> base date and day 1 would be 01-01-1900, but that seems a little
> convoluted.
>
> Neil Palmer wrote:
> > 
> > So could the 2 day difference in the calculations be because someone
> isn't
> > counting 1900 & 2000 as leap years ?
> > 
> > ...Neil
> > 
> > "James W. Kilgore" <eMail@James-W-Kilgore.com>
>
> > 
> > The following gave me 1899-12-30 as the base date
> > 
> >  H
> >  DCURRDATE        
> S              
> D   DATFMT(*ISO) INZ(D'2001-03-18')
> >  DBASEDATE        
> S              
> D   DATFMT(*ISO) INZ(D'2001-03-18')
> >  C    
> CURRDATE      SUBDUR   
> 36968:*D      BASEDATE
> > 
> C                  
> DSPLY                  
> BASEDATE
> > 
> C                  
> SETON                                       
> LR
> > 
> > Chris Beck wrote:
> > >
> > > Can someone tell the formula to convert 20010318  to
> 36968.
> > >
> > > This would be just like the DATEVALUE in Excel.
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---