Calculate the break between to dates

[#1]

Hello Community,

i attached a qv-file, that shows my problem. I want to calculate the break between two dates (end and start date).

Best regards,

Aylin

[whiteline]

Hi,

You can just subtract them.

=End-Start

[#3 · Accepted solution]

I have to use the peek funtion and then i can subtract the right values. like

Load

Product,
date(Start) as Start
date(End) as End

if([Start]>peek('End'),[Start]-peek('End')) as break



Resident abc

order by Product,Start ;