topic Maketime in difference months? in Management & Governance

Maketime in difference months?

lucasx15 — Tue, 27 Dec 2022 13:53:54 GMT

Hello everyone, I'm applying the data difference in a table using maketime, where the interval time needs to be less than 1 hour. However, it is counting incorrectly.

LOAD NR_CLIENT,
IF(Interval((DT_CHANGE)-(DT_AVAL))<=MakeTime(1,0,0),'S')AS FL_INTERVAL
RESIDENT ATEND_CLIENT_ALL;

Re: Maketime in difference months?

Or — Tue, 27 Dec 2022 14:08:50 GMT

DT_CHANGE - DT_AVAL is negative, ~ -16.2, so it is obviously smaller than MakeTime(1,0,0) which is ~0.42....

Perhaps you'll want to apply fabs() to the first part to avoid the issue of negatives?

Re: Maketime in difference months?

lucasx15 — Tue, 27 Dec 2022 14:11:32 GMT

The issue is that line shouldn't mark the 'S' because the interval between these two dates is >=1 hour. And I was confused without understanding

Re: Maketime in difference months?

Or — Tue, 27 Dec 2022 14:21:18 GMT

Interval() is a formatting function. It doesn't modify the underlying value, which as per my previous post is negative 16.2.