INTNX for hours

[Tommer]

Hi,

Here I want time 1.5 hours before date, but intnx is calculating 2 hours instead. What am I missing?

data chkl;
date="2021-02-01T09:30";
date2= intnx("hour",input(date,is8601dt.),-1.5,"s");
format date2 is8601dt.;
run;

[Tom · Accepted solution]

INTNX() is for changing by intervals.  Not fractions of an interval.

If you want to subtract an hour and a half just subtract an hour and a half.

date2= input(date,is8601dt.) - '01:30:00't  ;