Jean,
  Well, just shooting from the hip..."it depends" (tm = Bill Lancaster)...

  For compatibility mode:  

Calendar format dates are easy to subtract...it's getting a non calendar
date into that format...(if the date is YYMMDD format, you can use
YY*512+Day of year)...the YY is actually number of years since 1900, so
you're good until 2027.

  It's getting the Day of year that's the tricky part...

  For Native mode:

Check out HPDATECONVERT and HPDATEDIFF.



Rich Trapp <mailto:[log in to unmask]>  

 
Consulting for Agilent Technologies, Loveland, Colorado.

Managed Business Solutions <http://www.mbsnav.com/>  
200 South College Avenue 
Fort Collins, Colorado 80524-2811 
970.679.2221 (voice) 
970.669.3071 (fax) 



-----Original Message-----
From: LES BUREAUX DE CRÉDIT DU NORD INC [mailto:[log in to unmask]]
Sent: Wednesday, November 22, 2000 12:07 PM
To: [log in to unmask]
Subject: Looking for an SPL routine or intrinsic to calculate the
difference between 2 dates.


My programmer needs to find difference between the system date and the date
stored in a file and incorporate that function in an S.P.L. program. Do you
know of an intrinsic or a routine that will do the job?

Thank you,

Jean Huot
Northern Credit Bureaus Inc.