difference between current date and next occurance date

[#1]

Hi All,

Please find an attachment.QlikTech Admin

I want to take difference between date and next date of occurance.

For EX:  I am having ABC functional location and in that different notification nos. are there so for that one notification no's date minus

             next date of that function location during the month * 24. so how to handle it in script.

[Gysbert_Wassenaar]

It's unclear to me which date difference should be calculated. Can you give some examples?

[shane_spencer]

I use Interval for this. i.e.

interval ( EndDateTime - StartDateTime, 'mm') as Duration,

Perhaps with the data you have you need to combine this with Previous of Peek function?