Hi, I need to subtract two date fields in HYYMDS format and return the number of business days. Anyone have an idea how to do this?
Thanks in advance for your help!

This message has been edited. Last edited by: Kerry,

Here is one way to do it:

  

SET BUSDAYS = _MT_TF_

-SET &START_DATE = '20120416';
-SET &END_DATE   = '20120430';

DEFINE FILE CAR
START_DATE/YYMD WITH CAR = &START_DATE ;
END_DATE/YYMD 	       = &END_DATE ;
END
TABLE FILE CAR
PRINT
START_DATE
END_DATE
COMPUTE DIFF/I5 = DATEDIF(START_DATE,END_DATE,'BD');
BY CAR
IF RECORDLIMIT EQ 1
END

For Datetime format fields, you can use the HDIFF function.

I quick search of the forum for "SUBTRACT HYYMDS" would have given you the answer.

HDIFF doesn't account for Business Days.

BUSDAYS works with DATEDIF.

Thanks! The requirement has changed so I'm calculating using Calendar Days now. I'm now using HDIFF but I can't seem to get the decimal portion to show. Here's my DEFINE'd field:

NEWCT/D12.2=HDIFF(DATE1, DATE2, 'DAY', NEWCT);

However, only full days are shown. So, for example, if DATE1 = 2012/02/28 09:06:05 and DATE2 = 2012/03/12 14:09:14, I get 13 instead of 13.21. Is there anyway around this?

Instead of working with days, work with hours, minutes or seconds, then calc the days from that.

Wouldn't that cause problems around DST changes?

This is what was given as a solution, from a co-worker...

NEWCT/D12.2=HDIFF(DATE1,DATE2, 'MINUTE', NEWCT);

This will give you the number of minutes between the two dates. You would then need to add:

NEWCT2/D12.2=NEWCT/1440;

This will convert the minutes to days with a decimal.


Thanks for all of your suggestions!