Interval Date Issue

[#1]

Hello,

I am facing an issue with sum().

I have minutes calculated as

round(Interval(Date1-Date2,'mm')*(24*60)) as IntervalMinutes

For an data it comes 32 but when i write sum(IntervalMinutes) it shows 64.

Any idea

[its_anandrjs]

The dates are you using it is timestamp.

Regards

Anand

[#3]

Yes Of Course

[Anonymous]

What are the values of Date1 & Date2 and why multiply by 24*60 ?

[#5]

Previously i was getting 0 as difference hence used this logic

[#6]

Main thing is that when the value is 32 by a after multiplication then why it converts to 64 when sum()

[anbu1984]

If difference is zero, then how did you get 32 after multiplication?

Can you provide sample input or app

[#8]

Please find the attached Document

[#9]

Did not work

[#10]

Even i tried this

Interval(Timestamp(Date1,'M/D/YYYY h:mm:ss[.fff] TT')-Timestamp(Date2,'M/D/YYYY h:mm:ss[.fff] TT'),'mm')*(24*60))