Re: Date fields was: Quick question on indicators - more philosophical than anything else

Buck,

Really there's no additional calculations than what we have now.

We don't really currently use
daysDiff = %diff(%date(): datefld: *days);

Instead we do
if datefld=*zeros;
daysdiff = -1;
else;
daysDiff = %diff(%date(): datefld: *days);
endif;

So, how is that different than
if %nullind(datefld);
daysdiff = -1;
else;
daysDiff = %diff(%date(): datefld: *days);
endif;

Null fields are easier on the users. Instead of
select avg(salesAmt) from salesfile where salesAmt<>0;
They can use
select avg(salesAmt) from salesfile;

CREATE TABLE QTEMP.BUCK (SALESAMT DEC ( 15, 5), SOMEDATA CHAR (5 ))

Table BUCK created in QTEMP.

INSERT INTO QTEMP.BUCK (SALESAMT, SOMEDATA) VALUES(5.6, 'yo')

1 rows inserted in BUCK in QTEMP.

INSERT INTO QTEMP.BUCK (SOMEDATA) VALUES( 'hiyo')

1 rows inserted in BUCK in QTEMP.

INSERT INTO QTEMP.BUCK (SALESAMT, SOMEDATA) VALUES(5.2, 'bye')

1 rows inserted in BUCK in QTEMP.

select avg(salesamt) from qtemp.buck

returns 5.4



Rob Berendt