quote:

Syntax: How to Find the Number of Units Between Two Date-Time Values
HDIFF(value1, value2, 'component', outfield) where:

value1 - Date-time - Is the end date-time value, the name of a date-time field that contains the value, or an expression that returns the value.

value2 - Date-time - Is the start date-time value, the name of a date-time field that contains the value, or an expression that returns the value.

component - Alphanumeric - Is the name of the component to be used in the calculation enclosed in single quotation marks. If the component is a week, the WEEKFIRST parameter setting is used in the calculation.

outfield - Floating-point double-precision -Is the field that contains the result, or the format of the output value enclosed in single quotation marks. The format must be floating-point double-precision.

CONF_DIFF/D12 = HDIFF(DT_ADLSCONF, DT_ADLSINIT, 'SECOND', CONF_DIFF);
DL_AGE/D8     = HDIFF(EFFECTIVEDATE,DATEOFBIRTH,'YEAR','D8');
MINUTES/D20   = HDIFF(COMPLETION_DATE,CREATION_DATE,'MINUTE','D20') ;

-SET &MILSEC  = HDIFF(&ENDTIME, &BEGTIME, 'MILLISECOND', D12.2);

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server