Forum Discussion

Adham's avatar
Adham
Icon for Helper III rankHelper III
6 years ago

Calculate time between dates for each unique identifier

Hello All,   I have been stuck with this issue for a while and i would appreciate some help. I have got the following table.   ID Date 1 16/07/2020 14:11:12 1 17/07/2020 15:12:11 1...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Adham , Try like

time = Table[Date] -maxx(filter(Table,Table[Date] <earlier(Table[Date]) && Table[ID] =earlier(Table[ID])),Table[Date])