Re: Query calc # days

["Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>]

Gail,

my last post (repeated below) should give you approximately what you need -
in addition to changing the job date format.

I had some strange day calcs from the 2nd to last query I posted too, but
the last on should be close to what you need - assuming your dates are all
within the 1940-2039 date window, and that your date is in a 7 digit field,
CYYMMDD, or 0YYMMDD.

If the date isn't in that format, change the substring positions to match
your format.

Rick

D1          substr(digits(s1busdat),2,2)||'/'
            ||substr(digits(s1busdat),4,2)||'
            /'||substr(digits(s1busdat),6,2)

D2          substr(digits(s2busdat),2,2)||'/'
            ||substr(digits(s2busdat),4,2)||'
            /'||substr(digits(s2busdat),6,2)

DAYSDIFF    days(date(d2)) -
            days(date(d1))


-------original message---------
Got the info in YYMMDD no century code.  Yes, years are 00 for 2000, 02
for 2002 etc.  I also see some of the days did not calc correctly.   What
do you suggest?

Gail Crane
Johanson Manufacturing Corp.
phone 973-334-2676
gcrane@xxxxxxxxxxxxxxx